singapore app developer,web designer singapore,ios app development singapore,web development singapore,web design services singapore,design agency singapore,mobile app development singapore,developers in singapore,singapore website design,ios developer singapore,website development singapore,ruby on rails developer singapore,mobile application developer singapore,singapore mobile app developer,singapore web development,singapore web design,mobile apps development singapore,web application singapore,website designer singapore,website design singapore,app developer singapore,singapore mobile application developer,graphic designer in singapore,web design company singapore,mobile app developer singapore,mobile apps singapore,android developer singapore,mobile application development singapore,design firms in singapore,mobile developer singapore,app development singapore,web design singapore,singapore web design services,developer in singapore,mobile game developer singapore,web development company singapore,website 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:
WordPress Security