[New] restoring a mysql backup from a web to web ( without downloading the backup)

counter · 10-31-2007, 01:37 PM

[Still in-need to know other methods than the posted below please help]

hello
????: NamePros.com http://www.namepros.com/programming/390595-new-restoring-mysql-backup-web-web.html
i recently moved my site to a new server i moved the files but i still got to move the sql databases
i got a mysql backup of my forums posted online at an address similar to mysite.com/backups/mysql.sql

i need a way to restore this backup without downloading it to my pc and reuploading it using phpmyadmin
i need a faster way
btw i got cpanel 10

summary:
i got a mysql backup on my old server and i want to install it on the new one without downlaoding then reuploading

IMPORTANT THING
i got a script that can copy the sql backup file to the new server but i dont know if i copied the db to the new server where to move the backup to file to what directory

Plz guys help me

Alex. · 10-31-2007, 03:02 PM

Go into phpmyadmin, and export the data from a database.
Don't click the save as file button.

On the next page, a big textbox full of sql code should appear.
Go to your new server, open phpmyadmin, create a database, click the SQL tab, and copy the commands from the old server's textbox to the textbox on the new server's phpmyadmin page.
Press the rubmit / run / execute button, and the data should be imported into the new database.

dezinerite · 10-31-2007, 04:38 PM

Worked for me! I'm so glad, heheh...thanks!

counter · 10-31-2007, 11:51 PM

this can work bu the prob is the database is HUGE!
its exeeding the max execution time allowed so i need another way please
[if possible uploading the db as a file to my server and doing a trick to restore the database by coping it to the databases locaton (which i dont know where it is in Cpanel 10)]

please any suggestions

smagik · 11-01-2007, 02:18 AM

read from 1 database -> write the data to the other. A few lines of php code...

counter · 11-01-2007, 02:31 AM

am not a super phper i got slight idea about php

please can u help me in setting that script up

thx

counter · 11-02-2007, 11:50 AM

please any one could help

neroux · 11-02-2007, 05:15 PM

Do you have shell access on your machines? You could do a database export with mysqldump, then upload/download to/from your new machine and restore the database there.

counter · 11-03-2007, 04:01 AM

dont know how shell stuff work i dont think i got it
but i got a normal full backup backup (its 7gb my new server is much smaller i dont want to send all files)
anyways i got the backup on my server how can i install it

ds2007 · 11-03-2007, 04:11 AM

you can do it with free mysql tools like SQLyog
link: http://www.webyog.com

just connect to old database and at "DB" menu you can find "Copy database to different Host/DB" to upload your DB

its a very handy tool for mysql db to edit, update, download etc.

hope it helps

counter · 11-03-2007, 04:17 AM

wowow might be helpful
but do u mean tool is :SQLyog MySQL GUI - Community Edition?
is it a script i got to install on my server to use or a website

ds2007 · 11-03-2007, 04:19 AM

Originally Posted by counter

wowow might be helpful
????: NamePros.com http://www.namepros.com/showthread.php?t=390595
but do u mean tool is :SQLyog MySQL GUI - Community Edition?
is it a script i got to install on my server to use or a website

yeah community edition and is a desktop application so you have to download and install in your pc

counter · 11-03-2007, 05:25 AM

thx this is a good program but i faced a problem
i entered the msyql host as ftp.mysite.com
username also entered and password and port as 21 and i tested the connection
it showed this error
i couldnt connect why is that ? this error appeared
Error No. 2013
Lost connection to MySQL server during query

that what i am always getting

ds2007 · 11-03-2007, 05:31 AM

Originally Posted by counter

thx this is a good program but i faced a problem
i entered the msyql host as ftp.mysite.com
username also entered and password and port as 21 and i tested the connection
it showed this error
i couldnt connect why is that ? this error appeared
Error No. 2013
Lost connection to MySQL server during query

that what i am always getting

mysql host should be IP of your mysql db
username and password should be of mysql db as well not of ftp
for IP if you dont know then you can check it out with your host

counter · 11-03-2007, 05:40 AM

my host will take ages to reply

is there is anyway i can figure it out ?

ds2007 · 11-03-2007, 05:45 AM

if you have access to cpanel then go to "MySql"
after clicking mysql under "Access hosts" you can find the IP
remember you also need IP and user name and password of mysql of new server

counter · 11-03-2007, 05:52 AM

wowowowow
1 sec
i changed the port to 3306
i entered my domain name i think its working but an error is saying ACCESS DENIED with error 1045
how isnt the user and pass same as the cpanel user and pass ?

i need to view all db and not one

ds2007 · 11-03-2007, 06:19 AM

maybe you have used different username and password for mysql db
you can view users or create new one from where you got the ip

10-31-2007, 01:37 PM	THREAD STARTER #1 (permalink)
counter Account Closed Join Date: Apr 2007 Posts: 52	[New] restoring a mysql backup from a web to web ( without downloading the backup) [Still in-need to know other methods than the posted below please help] hello ????: NamePros.com http://www.namepros.com/programming/390595-new-restoring-mysql-backup-web-web.html i recently moved my site to a new server i moved the files but i still got to move the sql databases i got a mysql backup of my forums posted online at an address similar to mysite.com/backups/mysql.sql i need a way to restore this backup without downloading it to my pc and reuploading it using phpmyadmin i need a faster way btw i got cpanel 10 summary: i got a mysql backup on my old server and i want to install it on the new one without downlaoding then reuploading IMPORTANT THING i got a script that can copy the sql backup file to the new server but i dont know if i copied the db to the new server where to move the backup to file to what directory Plz guys help me Last edited by counter; 11-03-2007 at 06:11 AM.

10-31-2007, 04:38 PM	#3 (permalink)
dezinerite www.bpdir.com Join Date: Jul 2007 Posts: 3,051 Follow @bpdir	Worked for me! I'm so glad, heheh...thanks! __________________ Premium DoFollow Directory \| Seychelles Triathlon Federation \| Free Directory Since 2007!

11-02-2007, 05:15 PM	#8 (permalink)
neroux NamePros Regular Join Date: Oct 2006 Posts: 963	Do you have shell access on your machines? You could do a database export with mysqldump, then upload/download to/from your new machine and restore the database there. __________________ Paris loves CityPics -- Do not let others be treated this way!

11-03-2007, 04:11 AM	#10 (permalink)
ds2007 NamePros Regular Join Date: Aug 2007 Posts: 280	you can do it with free mysql tools like SQLyog link: http://www.webyog.com just connect to old database and at "DB" menu you can find "Copy database to different Host/DB" to upload your DB its a very handy tool for mysql db to edit, update, download etc. hope it helps __________________ [English Premier League] [Cartoons] [Travel Directory][Cricket] Taking offers->cartoonshow/s.tv

11-03-2007, 05:45 AM	#16 (permalink)
ds2007 NamePros Regular Join Date: Aug 2007 Posts: 280	if you have access to cpanel then go to "MySql" after clicking mysql under "Access hosts" you can find the IP remember you also need IP and user name and password of mysql of new server __________________ [English Premier League] [Cartoons] [Travel Directory][Cricket] Taking offers->cartoonshow/s.tv

10-31-2007, 03:02 PM	#2 (permalink)
Alex. Account Closed Join Date: Nov 2006 Location: Uk Posts: 601	Go into phpmyadmin, and export the data from a database. Don't click the save as file button. On the next page, a big textbox full of sql code should appear. Go to your new server, open phpmyadmin, create a database, click the SQL tab, and copy the commands from the old server's textbox to the textbox on the new server's phpmyadmin page. Press the rubmit / run / execute button, and the data should be imported into the new database.

10-31-2007, 11:51 PM	THREAD STARTER #4 (permalink)
counter Account Closed Join Date: Apr 2007 Posts: 52	this can work bu the prob is the database is HUGE! its exeeding the max execution time allowed so i need another way please [if possible uploading the db as a file to my server and doing a trick to restore the database by coping it to the databases locaton (which i dont know where it is in Cpanel 10)] please any suggestions

11-01-2007, 02:18 AM	#5 (permalink)
smagik New Member Join Date: Oct 2007 Posts: 8	read from 1 database -> write the data to the other. A few lines of php code...

11-01-2007, 02:31 AM	THREAD STARTER #6 (permalink)
counter Account Closed Join Date: Apr 2007 Posts: 52	am not a super phper i got slight idea about php please can u help me in setting that script up thx

11-02-2007, 11:50 AM	THREAD STARTER #7 (permalink)
counter Account Closed Join Date: Apr 2007 Posts: 52	please any one could help

11-03-2007, 04:01 AM	THREAD STARTER #9 (permalink)
counter Account Closed Join Date: Apr 2007 Posts: 52	dont know how shell stuff work i dont think i got it but i got a normal full backup backup (its 7gb my new server is much smaller i dont want to send all files) anyways i got the backup on my server how can i install it

11-03-2007, 04:17 AM	THREAD STARTER #11 (permalink)
counter Account Closed Join Date: Apr 2007 Posts: 52	wowow might be helpful but do u mean tool is :SQLyog MySQL GUI - Community Edition? is it a script i got to install on my server to use or a website

11-03-2007, 05:25 AM	THREAD STARTER #13 (permalink)
counter Account Closed Join Date: Apr 2007 Posts: 52	thx this is a good program but i faced a problem i entered the msyql host as ftp.mysite.com username also entered and password and port as 21 and i tested the connection it showed this error i couldnt connect why is that ? this error appeared Error No. 2013 Lost connection to MySQL server during query that what i am always getting

11-03-2007, 05:40 AM	THREAD STARTER #15 (permalink)
counter Account Closed Join Date: Apr 2007 Posts: 52	my host will take ages to reply is there is anyway i can figure it out ?

11-03-2007, 05:52 AM	THREAD STARTER #17 (permalink)
counter Account Closed Join Date: Apr 2007 Posts: 52	sa wowowowow 1 sec i changed the port to 3306 i entered my domain name i think its working but an error is saying ACCESS DENIED with error 1045 how isnt the user and pass same as the cpanel user and pass ? i need to view all db and not one Last edited by counter; 11-03-2007 at 06:05 AM. Reason: s

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

11-03-2007, 06:19 AM	#18 (permalink)
ds2007 NamePros Regular Join Date: Aug 2007 Posts: 280	maybe you have used different username and password for mysql db you can view users or create new one from where you got the ip __________________ [English Premier League] [Cartoons] [Travel Directory][Cricket] Taking offers->cartoonshow/s.tv