HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   Server Operation (http://www.howtoforge.com/forums/forumdisplay.php?f=5)
-   -   SQL dumps (http://www.howtoforge.com/forums/showthread.php?t=64)

woody 3rd May 2005 12:40

SQL dumps
 
I know I can do this by using phpMyAdmin, but I wonder if/how I can create sql dumps of my MySQL databases on the commandline?

sphere 3rd May 2005 16:41

Instructions for dumping a MySQL database can be found here...

http://dev.mysql.com/doc/mysql/en/mysqldump.html

on the MySQL website.

Cheers.

ingo 4th May 2005 11:57

If you don't have a database password (very insecure!), use this:

Code:

mysqldump -h <db_server, e.g. localhost> -u <db_user, e.g. root> -c --add-drop-table --add-locks --all --quick --lock-tables <db_name> > /path/to/your/sql_dump.sql
If you have a database password:

Code:

mysqldump -h <db_server, e.g. localhost> -u <db_user, e.g. root> -p<db_password, no space after -p!> -c --add-drop-table --add-locks --all --quick --lock-tables <db_name> > /path/to/your/sql_dump.sql
Ingo


All times are GMT +2. The time now is 18:26.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.