Additions:
Deletions:
MySql Data Files
The
MySql data files are located in
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
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
Additions:
# mysqldump -u wikkawiki -p mydbname > mydbbackup.sql
Deletions:
# mysqldump -u wikkawiki -p --databases mydbname > mydbbackup.sql
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
Additions:
Backup
# mysqldump --user=username -p --opt mydbname > mydbbackup.sql
Restore
# mysql --user=username -p mydbname < mydbbackup.sql
Deletions:
The oldest known version of this page was edited on
2006-05-30 07:09:43 by WikkaWiki (unregistered user)
REFERRERS
ToDo