Free Software Server Environment : MySqlBackup

HomePage :: Categories :: PageIndex :: RecentChanges
Search this site: FSSE.INFO is produced by "osde8info" :

Revision [748]

Most recent edit made on 2008-10-02 11:00:40 by FsseInfo

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



Revision [397]

Edited on 2007-06-30 17:56:25 by FsseInfo

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
#
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:

MySql Database Backup




Revision [394]

Edited on 2007-06-30 00:14:59 by Id8Ace (unregistered user)

Additions:

MySql Database Backup



Deletions:

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
#
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



Revision [374]

Edited on 2007-04-20 09:48:04 by FsseInfo

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
#
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:

MySql Database Backup




Revision [371]

Edited on 2007-04-20 01:18:29 by NuzIbw (unregistered user)

Additions:

MySql Database Backup



Deletions:

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
#
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



Revision [282]

Edited on 2006-11-29 04:13:10 by FsseInfo

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:

MySql Backup & Restore




Revision [259]

Edited on 2006-11-24 12:03:46 by FsseInfo

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
%%



Revision [132]

Edited on 2006-09-20 04:14:00 by FsseInfo

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



Revision [34]

The oldest known version of this page was edited on 2006-06-19 11:32:35 by FsseInfo

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

REFERRERS
MySqlAdministration
Page History :: 2008-10-02 11:00:40 feed icon :: Owner: FsseInfo :: Search:
Valid XHTML 1.0 Transitional∞ :: Valid CSS∞ :: Powered by WikkaWiki ∞
Page was generated in 0.2606 seconds