You may receive an error that says mysql was read from a dump file. It turns out that there are several ways to solve this problem, and we will discuss this a little later.
Reload into delete file written by mysqldump when referring to SQL statements, use it as input when editing MySQL client. If the dump archive was created mysqldump with --all-databases or Parameter --databases , es contains CREATE DATABASE and USE instructions, but in fact it is not mandatory to indicate the standard database in which Data: MySQL
wrapper>
Alternatively use in mysql a source command:
mysql> form dump.sql
If the file is a new unified database dump that does not contain CREATE DATABASE and The USE statements create Database first (if needed):
shell> mysqladmin creates db1
Then provide the database name when loading the placed file:
wrapper> mysql db1
Alternatively, you can create Database, select it as any database, set it to default and download the dump To submit:
mysql> CREATE DATABASE IF db1 does not exist;mysql> USE db1;mysql> original dump.sql
7.4.2. P Reloading SQL Backups
For Windows PowerShell users: because your character is "<" reserved for future use in PowerShell, alternative useful approach required, for example using quotes cmd.exe / c "mysql .
The content reproduced on this website is the property of the respective primary copyright holder. Oracle does not consider it in advance and does not necessarily reflect an opinion Oracle or another party.
By David Ashman Date of withdrawal: February May 2008 11:33
Google usually gives faster answers than the best forum on this subject;)
I searched for "load mysql dump file" and the first result was:
How can I reload the dump file to the index server after using mysqldump?How do I back up a MySQL database?May 25, 2003 3:09 AMRead the manual for mysqldump, especially the --opt option. Also discover the mainSection "Backup CodesAnd Databases ”in the“ Troubleshooting Common MySQL Injuries ”section. You can export the database to a file with: mysqldump -h hostname -u people --password = password databasename> filename You can restore the information in the database again: mysql -h hostname -oughout user --password = password database name
Fortect is the world's most popular and effective PC repair tool. It is trusted by millions of people to keep their systems running fast, smooth, and error-free. With its simple user interface and powerful scanning engine, Fortect quickly finds and fixes a broad range of Windows problems - from system instability and security issues to memory management and performance bottlenecks.
1. Download Fortect and install it on your computer
2. Launch the program and click "Scan"
3. Click "Repair" to fix any issues that are found
