How do I import large sql file to local LAMP (xampp) environment

Posted by mraslton on Server Fault See other posts from Server Fault or by mraslton
Published on 2011-03-04T15:13:17Z Indexed on 2011/03/04 15:26 UTC
Read the original article Hit count: 373

Filed under:
|
|
|
|

I have used Linux to import a large mysql dump file (into a new database), but am new to how the process works in a local LAMP environment using xampp, as xampp does not support SSH. I've dowloaded the large_dump_file.sql from the Linux server to my local system. I'm using Windows XP and have used xampp to setup LAMP. I am able to access the local_database via phpMyAdmin, but the dump file is too large to import using that app. I'm trying to import the file via the command prompt, but so far with no success.

At the prompt:
cd ..
cd ..
cd xampp
cd mysql
cd bin

I've found that mysqlimport is used to import .csv and .txt files, and mysql is used to import .sql files, but can't find documentation as to whether or not to use the -u -p options so I've tried many variations of the command with no luck. What would be the proper command?

I've modified the hosts, virtual-hosts conf, and apache config files. Do I need to change any other config files on my local system?

Thanks.

© Server Fault or respective owner

Related posts about Windows

Related posts about sql