MySQL help needed - GoFuckYourself.com

3Xguru · 05-22-2003, 08:54 AM

I have a large databse on my computer and I need to transfer all the data from my computer to my webserver.
Does anyone know how to transfer such a large database between 2 MySQL databases?

I have tried to export the database from the PHPMyAdmin pannel(with the feature that exports the database in a text file with all the inserts), but it doesn't work since the database is too big(over 50k records - about 50Mb). Any ideas? Is there a specialized software for something like this?

Any feedback appreciated.

Zorgman · 05-22-2003, 09:26 AM

Upload the 50MB file to your webserver and use ssh or telnet to insert it into the mysql database.

mysql -u username -p databasenamee < filename.sql

Also for reference - backing up

mysqldump -u username -p databasename > dumpfile.sql

It's been a while since I used this way, I hope it hasn't changed at all.

grumpy · 05-22-2003, 09:29 AM

50Mb shouldnt be any problem. Zorgman is right

3Xguru · 05-22-2003, 09:53 AM

Quote:

Originally posted by Zorgman
Upload the 50MB file to your webserver and use ssh or telnet to insert it into the mysql database.

mysql -u username -p databasenamee < filename.sql

Also for reference - backing up

mysqldump -u username -p databasename > dumpfile.sql

It's been a while since I used this way, I hope it hasn't changed at all.

Thanks for the feedback but I'm still in the dark.

I do not have the sql file on my local computer. The only file on the MySQL database I have found is a .myd file that's 52Mb
How do I create the sql file with the database inserts to upload to the server. The export feature on PHPMyAdmin does not seem to work with so many records.

Also I have no idea about where to upload the SQL file

HoiDaKalen · 05-22-2003, 10:14 AM

umm, your database is stored in files. i forgot which dir, but they are there somewhere. just look around in mysql dir.

Zorgman · 05-22-2003, 10:18 AM

In phpmyadmin you can dump the entire database to a file or if you have the latest version it can even zip that file.

An .sql file is basicly just a text file. It's named .sql to tell your its a database backup or related file rather then a .txt file.

If you have telnet or ssh use the above commands to dump your database OR you could hire someone to do it for you. There are many guys here that could help you out.

3Xguru · 05-22-2003, 10:37 AM

Quote:

Originally posted by Zorgman
In phpmyadmin you can dump the entire database to a file or if you have the latest version it can even zip that file.

An .sql file is basicly just a text file. It's named .sql to tell your its a database backup or related file rather then a .txt file.

If you have telnet or ssh use the above commands to dump your database OR you could hire someone to do it for you. There are many guys here that could help you out.

I know what an SQL file is. I have also tried to dump the database using PHPMyadmin but it doesn't seem to work. I'll try to download the latest version of PHPMyAdmin and see if it works better(or if it works at all)

Thanks for the help again!

hibbidiji · 05-22-2003, 10:42 AM

and dont forget what zorgman said... if you cant get phpmyadmin to do it (probably because of a time limit or file size problem in your PHP installation, you can always ssh in to the server and run
mysqldump -u username -p databasename > dumpfile.sql
it will ask you for a password then create dumpfile.sql... then you ftp in and download it... (it helps to put the path to your web folder or a folder you can easily ftp to in front of dumpfile.sql) then you follow zorgmans other suggestion and it will go in slick.
d

05-22-2003, 08:54 AM	#1
3Xguru Confirmed User Join Date: Sep 2001 Location: Iasi Posts: 1,281	MySQL help needed I have a large databse on my computer and I need to transfer all the data from my computer to my webserver. Does anyone know how to transfer such a large database between 2 MySQL databases? I have tried to export the database from the PHPMyAdmin pannel(with the feature that exports the database in a text file with all the inserts), but it doesn't work since the database is too big(over 50k records - about 50Mb). Any ideas? Is there a specialized software for something like this? Any feedback appreciated. __________________ -=Free Webmaster Tools=-

05-22-2003, 09:26 AM	#2
Zorgman Confirmed User Join Date: Aug 2002 Location: Sydney, Australia Posts: 6,103	Upload the 50MB file to your webserver and use ssh or telnet to insert it into the mysql database. mysql -u username -p databasenamee < filename.sql Also for reference - backing up mysqldump -u username -p databasename > dumpfile.sql It's been a while since I used this way, I hope it hasn't changed at all. __________________ ---

05-22-2003, 09:29 AM	#3
grumpy Too lazy to set a custom title Join Date: Jan 2002 Location: Holland Posts: 9,870	50Mb shouldnt be any problem. Zorgman is right __________________ Don't let greediness blur your vision \| You gotta let some shit slide icq - 441-456-888

05-22-2003, 10:18 AM	#6
Zorgman Confirmed User Join Date: Aug 2002 Location: Sydney, Australia Posts: 6,103	In phpmyadmin you can dump the entire database to a file or if you have the latest version it can even zip that file. An .sql file is basicly just a text file. It's named .sql to tell your its a database backup or related file rather then a .txt file. If you have telnet or ssh use the above commands to dump your database OR you could hire someone to do it for you. There are many guys here that could help you out. __________________ ---

05-22-2003, 10:42 AM	#8
hibbidiji Confirmed User Join Date: Sep 2002 Location: Las Vegas Posts: 208	and dont forget what zorgman said... if you cant get phpmyadmin to do it (probably because of a time limit or file size problem in your PHP installation, you can always ssh in to the server and run mysqldump -u username -p databasename > dumpfile.sql it will ask you for a password then create dumpfile.sql... then you ftp in and download it... (it helps to put the path to your web folder or a folder you can easily ftp to in front of dumpfile.sql) then you follow zorgmans other suggestion and it will go in slick. d __________________ ---------------

05-22-2003, 10:14 AM	#5
HoiDaKalen Registered User Join Date: Apr 2002 Posts: 51	umm, your database is stored in files. i forgot which dir, but they are there somewhere. just look around in mysql dir.