Additions:
but instead of just trying to copy these directly you should use the
MySql utilities to backup and restore your database
See also
MySqlDump and
MySqlRestore
Deletions:
but instead of just trying to copy these directly you should use the
MySqlDump and "mysql" commands to backup and restore your database
Additions:
MySql Database Backup & Restore
The
MySql data files are located in
but instead of just trying to copy these directly you should use the
MySqlDump and "mysql" commands to backup and restore your database
Quick Backup
#
cat dblist | while read -r db
do
echo $db
mysqldump --add-drop-table --allow-keywords --quote-names $db > $db.sql
done
Quick Restore
#
cat dblist | while read -r db
do
echo $db
mysql -e "DROP DATABASE IF EXISTS \`$db\`"
mysql -e "CREATE DATABASE IF NOT EXISTS \`$db\`"
mysql $db < $db.sql
done
REFERRERS
MySqlAdministration
Deletions:
Additions:
Deletions:
MySql Database Backup & Restore
The
MySql data files are located in
but instead of just trying to copy these directly you should use the
MySqlDump and "mysql" commands to backup and restore your database
Quick Backup
#
cat dblist | while read -r db
do
echo $db
mysqldump --add-drop-table --allow-keywords --quote-names $db > $db.sql
done
Quick Restore
#
cat dblist | while read -r db
do
echo $db
mysql -e "DROP DATABASE IF EXISTS \`$db\`"
mysql -e "CREATE DATABASE IF NOT EXISTS \`$db\`"
mysql $db < $db.sql
done
REFERRERS
MySqlAdministration
Additions:
MySql Database Backup & Restore
The
MySql data files are located in
but instead of just trying to copy these directly you should use the
MySqlDump and "mysql" commands to backup and restore your database
Quick Backup
#
cat dblist | while read -r db
do
echo $db
mysqldump --add-drop-table --allow-keywords --quote-names $db > $db.sql
done
Quick Restore
#
cat dblist | while read -r db
do
echo $db
mysql -e "DROP DATABASE IF EXISTS \`$db\`"
mysql -e "CREATE DATABASE IF NOT EXISTS \`$db\`"
mysql $db < $db.sql
done
REFERRERS
MySqlAdministration
Deletions:
Additions:
Deletions:
MySql Database Backup & Restore
The
MySql data files are located in
but instead of just trying to copy these directly you should use the
MySqlDump and "mysql" commands to backup and restore your database
Quick Backup
#
cat dblist | while read -r db
do
echo $db
mysqldump --add-drop-table --allow-keywords --quote-names $db > $db.sql
done
Quick Restore
#
cat dblist | while read -r db
do
echo $db
mysql -e "DROP DATABASE IF EXISTS \`$db\`"
mysql -e "CREATE DATABASE IF NOT EXISTS \`$db\`"
mysql $db < $db.sql
done
REFERRERS
MySqlAdministration
Additions:
MySql Database Backup & Restore
Quick Backup
#
cat dblist | while read -r db
do
echo $db
mysqldump --add-drop-table --allow-keywords --quote-names $db > $db.sql
done
==Quick Restore==
(bash)
#
cat dblist | while read -r db
do
echo $db
mysql -e "DROP DATABASE IF EXISTS \`$db\`"
mysql -e "CREATE DATABASE IF NOT EXISTS \`$db\`"
mysql $db < $db.sql
done
Deletions:
Additions:
but instead of just trying to copy these directly you should use the
MySqlDump and "mysql" commands to backup and restore your database
Deletions:
but instead of just trying to copy these directly you should use the "mysqldump" and "mysql" commands to backup and restore your database
Backup
$ mysqldump -u mysqluser -p mydbname > mydbbackup.sql
or
$ mysqldump --user=mysqluser --password --databases mydbname > mydbbackup.sql
Backup Structure only
$ mysqldump -u mysqluser -p mydbname --hex-blob --no-data --skip-quote-names > mydbnamestruct.sql
Restore
$ mysql -u username -p mydbname < mydbbackup.sql
or
$ mysql --user=username --password mydbname < mydbbackup.sql
%%
Additions:
MySql Backup & Restore
but instead of just trying to copy these directly you should use the "mysqldump" and "mysql" commands to backup and restore your database
Backup
$ mysqldump -u mysqluser -p mydbname > mydbbackup.sql
$ mysqldump --user=mysqluser --password --databases mydbname > mydbbackup.sql
Backup Structure only
$ mysqldump -u mysqluser -p mydbname --hex-blob --no-data --skip-quote-names > mydbnamestruct.sql
Restore
$ mysql -u username -p mydbname < mydbbackup.sql
$ mysql --user=username --password mydbname < mydbbackup.sql
Deletions:
MySql Data Files
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
# mysqldump --user=wikkawiki --password --databases mydbname > mydbbackup.sql
Restore
# mysql -u username -p mydbname < mydbbackup.sql
# mysql --user=username --password mydbname < mydbbackup.sql
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
REFERRERS
MySqlAdministration