MySQL Heavy Uploads

Hi All,

Does anybody know how to upload heavy data (sql queries) to MySql database.
Heavy like more than 100mb?

PhpMyAdmin allows some particular amount like 30mb or so.

What is any good solution?

Pls help.

Thanks,
Smruti.

 

If you have ssh access, you can do it from the command line.

Programs like navicat (http://www.navicat.com/) can normally do it as well. Generally with phpmyadmin, your limiting factor is php's parameters and not the database. You have to bypass php to get around the limitations.

 

The best tool by far that I've used is called BigDump. Google it and it's the first link. It staggers to the imports into small chunks to achieve faster speeds. Give it a shot and you should be pleasantly surprised

 

Ask your host to do this for you.

 

Also a great idea. Any good host will do this for you given that you place the DB in the root directory as a .sql or .tar.gz

I've done it many times with HostGator. No issues

 

Compress the data into a gzip - this will shrink it for uploading, then unzip it on the server and then SSH into your server using the mysqladmin commands for importing. Google "ssh mysql import".

Good luck

 

Hello,

¿Do you have SSH access?

You can do an upload of a big database in seconds, using putty.

Download putty here: http://www.chiark.greenend.org.uk/~sgtatham/putty/download.html

Install putty. Login with the IP of your host, your root user and password.

Upload the database you want to import in a sql file to your server using an ftp client like smartftp, cuteftp... etc

Once in the command window, type this, copy and paste:

mysql -u yourmysqlusername -p mysqldatabasename < /path/to/your/file.sql

replace yourmysqlusername with the username for MySQL

replace mysqldatabasename with the actual name of the database

replace /path/to/your/file.sql with the location and name of the database you have uploaded in a sql file to your server using ftp and the one which will be imported to the actual database

Tell me if you need more help.

 

Hi,

thanks a lot to all for ur replies.

BigDump - I get error like
"dont have line break after query end" .. i tried doing so, but i guess
it takes only 300 lines in a single query and i have much more.

Putty - i dont have SSH access.

Any other good solution buddys?

thanks.

 

Split it in several small parts...

 

Try navicat. They offer a free trial. I've used it on 10Gb+ database restores.

 

there are lot of options available, u can use mysql front

 

Here is a list of MySQL GUIs to select from.