GoFuckYourself.com - Adult Webmaster Forum - View Single Post - Whats the smart way to have a database and testing server for a social site?

HomerSimpson · 03-10-2009, 09:38 AM

there are easier ways to backup/restore database than with phpMyAdmin
for example from root:

Backup database

Code:

mysqldump db_name -r file_name.sql

Import database

Code:

mysql -uUSER -pPASS DB_NAME < FILE.SQL

this is much faster and easier way to backup and specially to restore a database

03-10-2009, 09:38 AM
HomerSimpson Too lazy to set a custom title Industry Role: Join Date: Sep 2005 Location: Springfield Posts: 13,826	there are easier ways to backup/restore database than with phpMyAdmin for example from root: Backup database Code: mysqldump db_name -r file_name.sql Import database Code: mysql -uUSER -pPASS DB_NAME < FILE.SQL this is much faster and easier way to backup and specially to restore a database __________________ Make a bank with Chaturbate - the best selling webcam program Ads that can't be block with AdBlockers !!! /// Best paying popup program (Bitcoin payouts) !!! PHP, MySql, Smarty, CodeIgniter, Laravel, WordPress, NATS... fixing stuff, server migrations & optimizations... My ICQ: 27429884 \| Email: