Jump to content

Converting & Uploading SQL Files


scott botkins

Recommended Posts

I have 2 questions that may be easy to answer.

 

1. What is the best way to convert a .mdb file to .sql?

 

2. What is the best way to upload the sql file through phpmyadmin when it's 80mb? I keep getting timeouts.

 

Thanks a ton for your help!

 

1. not sure, maybe via ODBC?

2. see if you can get to a CLI, and do it from there.

Scott, if you have shell access this can be done easy from command line by using one of the three lines below. Most hosting providers allow for Shell access these days.

 

for local host

$ mysql -u username -p -h localhost data-base-name < data.sql

 

If you have dedicated database server, replace localhost name with actual server name or IP address:

$ mysql -u username -p -h 202.54.1.10 databasename < data.sql

 

OR use hostname such as mysql.hosting.com

$ mysql -u username -p -h mysql.hosting.com database-name < data.sql

 

 

 

 

 

 

heh, more work for them. Just upload the file to your webspace and call support. they shouldnt have an issue importing that baby for you. That would be the easiest way to import a large file, if they give you any flack check out dreamhost.com =)

 

This is another possability but Ive never used it, just came across it while googling.

 

http://www.ozerov.de/bigdump.php

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.