web design company singapore,design agency singapore,website development singapore,developers in singapore,app developer singapore,website designer singapore,graphic designer in singapore,web development company singapore,android developer singapore,mobile application development singapore,ios app development singapore,ruby on rails developer singapore,mobile application developer singapore,website design singapore,developer in singapore,mobile app developer singapore,singapore mobile app developer,mobile apps singapore,web design services singapore,mobile app development singapore,app development singapore,web design singapore,web application singapore,web designer singapore,website developer singapore,singapore website design,mobile developer singapore,web development singapore,singapore web design services,design firms in singapore,singapore mobile application developer,mobile game developer singapore,singapore web development,singapore app developer,mobile apps development singapore,ios developer singapore,singapore web design

Backuping and restoring a single table using mysqldump

mysqldump can retrieve and dump table contents row by row, or it can retrieve the entire content from a table and buffer it in memory before dumping it. Buffering in memory can be a problem if you are dumping large tables. To dump tables row by row, use the –quick option (or –opt, which enables –quick). The –opt option (and hence –quick) is enabled by default, so to enable memory buffering, use –skip-quick.

Backuping a single table from a database

mysqldump -u -p database_one table_name > /var/www/backups/table_name.sql

Restoring the table into another database

mysql -u -p database_two < /var/www/backups/table_name.sql

%d bloggers like this: