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

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: