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
See also
MySqlDump and MySqlRestore
Deletions:
Additions:
===MySql Database Backup & Restore===
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 to backup and restore your database
==Quick Backup==
%%(bash)
#
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
%%
----
REFERRERS
{{backlinks}}
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 to backup and restore your database
==Quick Backup==
%%(bash)
#
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
%%
----
REFERRERS
{{backlinks}}
Deletions:
Additions:
===MySql Database Backup
Deletions:
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 to backup and restore your database
==Quick Backup==
%%(bash)
#
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
%%
----
REFERRERS
{{backlinks}}
Additions:
===MySql Database Backup & Restore===
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 to backup and restore your database
==Quick Backup==
%%(bash)
#
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
%%
----
REFERRERS
{{backlinks}}
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 to backup and restore your database
==Quick Backup==
%%(bash)
#
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
%%
----
REFERRERS
{{backlinks}}
Deletions:
Additions:
===MySql Database Backup
Deletions:
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 to backup and restore your database
==Quick Backup==
%%(bash)
#
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
%%
----
REFERRERS
{{backlinks}}
Additions:
===MySql Database Backup & Restore===
==Quick Backup==
%%(bash)
#
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
==Quick Backup==
%%(bash)
#
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:
==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
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:
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