After using mysqldump, how can I load dump file back to database server? How can I back up a MySQL database? May 25th, 2003 03:09 Read the manual on mysqldump, especially option --opt. Also, check the section "Database backups", under "Solving common problems with MySQL". You can dump the database into a file using: mysqldump -h hostname -u user --password=password databasename > filename you can restore the info to the database again using: mysql -h hostname -u user --password=password databasename < filename
|How to load database from a dump file||Leila Lappin||02/06/2008 11:01AM|
|Re: How to load database from a dump file||David Ashman||02/06/2008 11:33AM|
|Re: How to load database from a dump file||Leila Lappin||02/06/2008 11:56AM|
Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.