IMPORT LARGE AMOUNT OF DATA INTO MYSQL

I have a large drupal db that I'm moving from one installation of MySQL to an installation of WAMPSERVER -  I get errors from the phpmyadmin saying that the data is too large for it to handle.

What do I do to import the data? OR is there a better way to basically move the drupal database?
I've tried to hack WAMPServer to access the original mysql, but no luck.

Thanks!
"This ain't rocket science, so why won't it fly" - unknown.
PhotoMan2000Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

theGhost_k8Database ConsultantCommented:
Try using command prompt:
mysql -uroot -p DATABASENAME < FILE.SQL

If you're loading it to remote machine then you may use -h option:
mysql -uroot -p -hIPADDRESS/HOSTNAME DATABASENAME < FILE.SQL
0
PhotoMan2000Author Commented:
Hi theGhost....

I generally use the MySQL Query browser tools that come with MySQL -- is there a difference in the resulting file?
0
webwyzsystemsCommented:
Not sure how you are moving data around - or if you are at the console...could some default limits be affecting things?
upload_max_filesize (Default 2M)
memory_limit (Default 16M)
post_max_size (Default 8M)
You can edit php.ini to increase all if necessary.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
10 Tips to Protect Your Business from Ransomware

Did you know that ransomware is the most widespread, destructive malware in the world today? It accounts for 39% of all security breaches, with ransomware gangsters projected to make $11.5B in profits from online extortion by 2019.

PhotoMan2000Author Commented:
so far nothing is working - I increased those limits to 120MB (my data file is 106mb)

Do know if the wamserver can be hacked to read the datafile of the orginal db? (both are local and on the same computer)
0
hieloCommented:
>>I generally use the MySQL Query browser tools that come with MySQL
If I am not mistaken that utility has a sub menu option (under "File" I believe) that allows you to select a .sql file and will execute it for you. Try that.
0
theGhost_k8Database ConsultantCommented:
You shall not find any issue while by loading sql through command prompt.
Meanwhile documentation for wampserver says:

1.16 I cannot upload big dump files (memory, HTTP or timeout problems).

Starting with version 2.7.0, the import engine has been re?written and these
problems should not occur. If possible, upgrade your phpMyAdmin to the latest
version to take advantage of the new import features.

The first things to check (or ask your host provider to check) are the values
of upload_max_filesize, memory_limit and post_max_size in the php.ini
configuration file. All of these three settings limit the maximum size of data
that can be submitted and handled by PHP. One user also said that post_max_size
and memory_limit need to be larger than upload_max_filesize.

There exist several workarounds if your upload is too big or your hosting
provider is unwilling to change the settings:

  * Look at the $cfg['UploadDir'] feature. This allows one to upload a file to
    the server via scp, ftp, or your favorite file transfer method. PhpMyAdmin
    is then able to import the files from the temporary directory. More
    information is available in the Configuration section of this document.
  * Using a utility (such as BigDump) to split the files before uploading. We
    cannot support this or any third party applications, but are aware of users
    having success with it.
  * If you have shell (command line) access, use MySQL to import the files
    directly. You can do this by issuing the "source" command from within
    MySQL: source filename.sql.
0
PhotoMan2000Author Commented:
none.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Drupal

From novice to tech pro — start learning today.