The backup data table import less mysql tables-CodePudding

Foreword: branch to do development, online database backup, import local found lack of 6 tables,
1. Baidu search, there may be stored procedures need mysqldump backup plus additional parameters, not make
2. In the Linux environment grep - e backup file keyword search, found, after the analysis should be import problems
3. Check the production, the local database version select version () found that production of 5.6 5.5 local
4. Go to the website to download version 5.6, download speed is too slow to find friends copy of green -installation version 5.7
5. Uninstall mysql5.5 version, installation time to join the service first, the.net start mysql, prompt start failure need to initialize, command baidu, normal after the restart, configure my. Ini, skip the login password, login using alert to modify password, the user table using the update do almost fail at the beginning, note: high version update to modify the password
6. Create a database, import, configure a JDBC, start the project, all OK, a day of trouble instantly wiped out

The last article on the bus rapid transit home record to send more than an hour's journey, home version right pit

CodePudding user response:

refer to the building of Kings is the reply of pit:

introduction: do branch development, online database backup, import local found lack of 6 tables,
1. Baidu search, there may be stored procedures need mysqldump backup plus additional parameters, not make
2. In the Linux environment grep - e backup file keyword search, found, after the analysis should be import problems
3. Check the production, the local database version select version () found that production of 5.6 5.5 local
4. Go to the website to download version 5.6, download speed is too slow to find friends copy of green -installation version 5.7
5. Uninstall mysql5.5 version, installation time to join the service first, the.net start mysql, prompt start failure need to initialize, command baidu, normal after the restart, configure my. Ini, skip the login password, login using alert to modify password, the user table using the update do almost fail at the beginning, note: high version update to modify the password
6. Create a database, import, configure a JDBC, start the project, all OK, a day of trouble instantly wiped out

The last article on the bus rapid transit home record to send more than an hour's journey, wrong version pit home

This logical backup recovery is less complex, with a high version, set up a library and users, direct import, problems of the building Lord version import from high to low version to appear problem,