Converting & Uploading SQL Files

[scott botkins]

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!

[fenway]

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 botkins]

What's a CLI? I can figure it out if I get some more details on it or even a tutorial. I uploaded the sql file to my server in hope there's a way to upload it into the phpmyadmin that way.

[owen.aaron]

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

 

 

 

 

 

 

[scott botkins]

I'm using godaddy and they don't allow shell access.

[owen.aaron]

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