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