Greenguy's Board - View Single Post

Cleo · 2016-05-11, 09:58 AM

I don't use PhpMyAdmin for dumps and restores.

I log into my server to open up a shell to my server.

To Dump

Code:

/usr/bin/mysqldump -u'DATABASENAME' -p'DATABASEPASSORD' --opt 'DATABASENAME' > /PATHTO

DUMP

To Restore

Code:

mysql -u 'DATABASENAME' -p 'DATABASENAME' < /PATHTODUMP

2016-05-11, 09:58 AM	#2
Cleo Subversive filth of the hedonistic decadent West Join Date: Mar 2003 Location: Southeast Florida Posts: 27,936	I don't use PhpMyAdmin for dumps and restores. I log into my server to open up a shell to my server. To Dump Code: /usr/bin/mysqldump -u'DATABASENAME' -p'DATABASEPASSORD' --opt 'DATABASENAME' > /PATHTO DUMP To Restore Code: mysql -u 'DATABASENAME' -p 'DATABASENAME' < /PATHTODUMP __________________ Free Rides on Uber and Lyft Uber Car: uberTzTerri Lyft Car: TZ896289