Open Source Desktop Environment: MySql Backup

Revision [649]

Most recent edit made on 2006-08-18 03:21:51 by WikkaWiki (unregistered user)

Additions:

MySql Backup

Deletions:

MySql Data Files

The MySql data files are located in

/var/lib/mysql

but instead of just trying to copy these directly you should use the "mysqldump" and "mysql" commands

Backup

# mysqldump -u wikkawiki -p mydbname > mydbbackup.sql
or
# mysqldump --user=wikkawiki --password --databases mydbname > mydbbackup.sql

Restore

# mysql -u username -p mydbname < mydbbackup.sql
or
# mysql --user=username --password mydbname < mydbbackup.sql

Revision [466]

Edited on 2006-05-31 11:35:45 by WikkaWiki (unregistered user)

Additions:

MySql Data Files

The MySql data files are located in
/var/lib/mysql
but instead of just trying to copy these directly you should use the "mysqldump" and "mysql" commands

Revision [449]

Edited on 2006-05-30 12:32:11 by WikkaWiki (unregistered user)

Additions:

# mysqldump -u wikkawiki -p mydbname > mydbbackup.sql

Deletions:

# mysqldump -u wikkawiki -p --databases mydbname > mydbbackup.sql

Revision [448]

Edited on 2006-05-30 12:31:05 by WikkaWiki (unregistered user)

Additions:

# mysqldump -u wikkawiki -p --databases mydbname > mydbbackup.sql
or
# mysqldump --user=wikkawiki --password --databases mydbname > mydbbackup.sql
# mysql -u username -p mydbname < mydbbackup.sql
or
# mysql --user=username --password mydbname < mydbbackup.sql

Deletions:

# mysqldump --user=username -p --opt mydbname > mydbbackup.sql
# mysql --user=username -p mydbname < mydbbackup.sql

Revision [439]

Edited on 2006-05-30 07:20:33 by WikkaWiki (unregistered user)

Additions:

Backup

 # mysqldump --user=username -p --opt mydbname > mydbbackup.sql

Restore

 # mysql --user=username -p mydbname < mydbbackup.sql

Deletions:

Revision [432]

The oldest known version of this page was edited on 2006-05-30 07:09:43 by WikkaWiki (unregistered user)

REFERRERS
ToDo