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