scott botkins Posted June 11, 2007 Share Posted June 11, 2007 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! Quote Link to comment https://forums.phpfreaks.com/topic/55089-converting-uploading-sql-files/ Share on other sites More sharing options...
fenway Posted June 11, 2007 Share Posted June 11, 2007 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. Quote Link to comment https://forums.phpfreaks.com/topic/55089-converting-uploading-sql-files/#findComment-272417 Share on other sites More sharing options...
scott botkins Posted June 11, 2007 Author Share Posted June 11, 2007 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. Quote Link to comment https://forums.phpfreaks.com/topic/55089-converting-uploading-sql-files/#findComment-272705 Share on other sites More sharing options...
owen.aaron Posted June 11, 2007 Share Posted June 11, 2007 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 Quote Link to comment https://forums.phpfreaks.com/topic/55089-converting-uploading-sql-files/#findComment-272727 Share on other sites More sharing options...
scott botkins Posted June 11, 2007 Author Share Posted June 11, 2007 I'm using godaddy and they don't allow shell access. Quote Link to comment https://forums.phpfreaks.com/topic/55089-converting-uploading-sql-files/#findComment-272737 Share on other sites More sharing options...
owen.aaron Posted June 11, 2007 Share Posted June 11, 2007 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 Quote Link to comment https://forums.phpfreaks.com/topic/55089-converting-uploading-sql-files/#findComment-272740 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.