Results 1 to 7 of 7
-
8th Sep 2009, 11:48 AM #1OP
Database restore through SSH
i am a noob in ssh so guys tell me frm first step to last in restoring a database thro ssh in cpanel
edit : ssh is enabled in that cpanelGoPantheoN Reviewed by GoPantheoN on . Database restore through SSH i am a noob in ssh so guys tell me frm first step to last in restoring a database thro ssh in cpanel edit : ssh is enabled in that cpanel Rating: 5
-
8th Sep 2009, 12:04 PM #2BannedWebsite's:
SmartWarez.org SwoImage.com MazaOnline.comYou will need the database username, password and database name, and putty
After you ssh into OLD server, type "mysqldump -u USER_NAME -p DB_NAME | gzip > FILE.sql.gz"
Enter the database password when it asks. Then, usinf FTP or sFTP, copy the FILE.sql.gz file from the OLD server to the NEW server. (Presumably by copying it from OLD server to your PC and then to NEW server.)
After you ssh into NEW server, type "gunzip < FILE.sql.gz | mysql -u USER_NAME -p DB_NAME"
Enter the database password when it asks. When it is done, your database will be copied to the new server.
Restoring . ssh to new host (make sure the database actually exists!)
mysql database -uusername -p < database.sql
or simply mysql database -uusername -p
enter password
source database.sql
PM me if you need more help.
-
8th Sep 2009, 12:10 PM #3OP
oh ok bro will try
-
8th Sep 2009, 01:54 PM #4Member
in shh type:
mysql -uyour_dbuser -pyour_dbname </home/location/of/database/data.sql
hit enter
it will then ask for password of database enter it and hit enter
you could also do this:
cd /home/location/of/database
mysql -uyour_dbuser -pyour_dbname <data.sql
hit enter
it will then ask for password of database enter it and hit enter
-
9th Sep 2009, 12:02 PM #5Member
-
16th Sep 2009, 01:22 PM #6OP
ty SmartWareZ & r0ck
-
16th Sep 2009, 03:58 PM #7MemberWebsite's:
security-shell.info helldownunder.inThanx For Info....
Sponsored Links
Thread Information
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Similar Threads
-
Best plugin to backup and restore database ?
By matriX in forum WordpressReplies: 2Last Post: 16th Feb 2012, 06:47 AM -
Database won't restore propertly Emergency!
By DuckBre in forum Technical Help Desk SupportReplies: 5Last Post: 21st Sep 2011, 09:25 AM -
How to restore my database
By souvikroy1111 in forum Hosting DiscussionReplies: 4Last Post: 28th Jul 2011, 04:15 PM -
VBulletin Database restore... Urgent please help
By shariq27 in forum vBulletinReplies: 5Last Post: 3rd Oct 2010, 08:23 AM -
Can any one tell me script to restore database??
By anuragblr in forum Webmaster DiscussionReplies: 6Last Post: 27th Jul 2009, 06:34 PM
themaManager - edit and manage...
Version 4.03 released. Open older version (or...