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