CountryGirl Posted January 13, 2010 Share Posted January 13, 2010 Hi all, The company I am working for decided to change web hosts for their website. We've run into one problem after another and now I've got to figure one last thing out. And, I can't get it to work! I need some help . I exported the PHPMyAdmin/MySQL database as a zipped sql file which we had at the previous webhost. I'm trying to upload that to the new PHPMyAdmin and I can't figure out how to get it uploaded. Every tutorial I see says to go to the SQL tab in PHPMyAdmin, and upload the text file there with import file option. I don't have that with my version of PHPMyAdmin (v. 5). I do have an import tab at the top and I've tried upload the file there and I don't get anywhere. The error says the database is too big to import. How do I solve this problem??? The folks at our webhost are not very helpful with this, so I don't get anywhere with them! Thanks! Qadoshyah Quote Link to comment https://forums.phpfreaks.com/topic/188389-need-help-importing-a-database-to-mysqlphpmyadmin/ Share on other sites More sharing options...
trq Posted January 13, 2010 Share Posted January 13, 2010 If your database is too big the server may timeout (through http) before it can complete the request. Have you got shell access to your hosting account? You can simply import your database via the command line mysql client. Quote Link to comment https://forums.phpfreaks.com/topic/188389-need-help-importing-a-database-to-mysqlphpmyadmin/#findComment-994524 Share on other sites More sharing options...
CountryGirl Posted January 13, 2010 Author Share Posted January 13, 2010 If your database is too big the server may timeout (through http) before it can complete the request. Have you got shell access to your hosting account? You can simply import your database via the command line mysql client. I'm not sure if I have shell access to the hosting account. How exactly could I find that out? Or get it? Thanks! Qadoshyah Quote Link to comment https://forums.phpfreaks.com/topic/188389-need-help-importing-a-database-to-mysqlphpmyadmin/#findComment-994528 Share on other sites More sharing options...
trq Posted January 13, 2010 Share Posted January 13, 2010 How exactly could I find that out? Ask your hosting provider. Quote Link to comment https://forums.phpfreaks.com/topic/188389-need-help-importing-a-database-to-mysqlphpmyadmin/#findComment-994531 Share on other sites More sharing options...
CountryGirl Posted January 14, 2010 Author Share Posted January 14, 2010 How exactly could I find that out? Ask your hosting provider. Aright, thanks! I will look into that! Qadoshyah Quote Link to comment https://forums.phpfreaks.com/topic/188389-need-help-importing-a-database-to-mysqlphpmyadmin/#findComment-994565 Share on other sites More sharing options...
CountryGirl Posted January 14, 2010 Author Share Posted January 14, 2010 Okay, I have Shell access to the account. How exactly do I get the database uploaded now? Using what commands? Please explain, as this is pretty new to me . Thanks so much for the help! Qadoshyah Quote Link to comment https://forums.phpfreaks.com/topic/188389-need-help-importing-a-database-to-mysqlphpmyadmin/#findComment-994989 Share on other sites More sharing options...
Mark1inLA Posted January 14, 2010 Share Posted January 14, 2010 Okay, I have Shell access to the account. How exactly do I get the database uploaded now? Using what commands? Please explain, as this is pretty new to me . Thanks so much for the help! Qadoshyah I believe this will do the trick: You can load the dump file back into the server like this: shell> mysql db_name < backup-file.sql taken from: http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html Quote Link to comment https://forums.phpfreaks.com/topic/188389-need-help-importing-a-database-to-mysqlphpmyadmin/#findComment-995070 Share on other sites More sharing options...
CountryGirl Posted January 14, 2010 Author Share Posted January 14, 2010 Okay, I have Shell access to the account. How exactly do I get the database uploaded now? Using what commands? Please explain, as this is pretty new to me . Thanks so much for the help! Qadoshyah I believe this will do the trick: You can load the dump file back into the server like this: shell> mysql db_name < backup-file.sql taken from: http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html And, would I use something like PuTTY to put that command into? Where would I put that command? PuTTY has me a bit confused . Thanks! Qadoshyah Quote Link to comment https://forums.phpfreaks.com/topic/188389-need-help-importing-a-database-to-mysqlphpmyadmin/#findComment-995077 Share on other sites More sharing options...
Mark1inLA Posted January 14, 2010 Share Posted January 14, 2010 Okay, I have Shell access to the account. How exactly do I get the database uploaded now? Using what commands? Please explain, as this is pretty new to me . Thanks so much for the help! Qadoshyah I believe this will do the trick: You can load the dump file back into the server like this: shell> mysql db_name < backup-file.sql taken from: http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html And, would I use something like PuTTY to put that command into? Where would I put that command? PuTTY has me a bit confused . Thanks! Qadoshyah yes, if its a linux box, you putty into it. This link should help after you login: http://dev.mysql.com/doc/refman/5.0/en/mysql.html Quote Link to comment https://forums.phpfreaks.com/topic/188389-need-help-importing-a-database-to-mysqlphpmyadmin/#findComment-995095 Share on other sites More sharing options...
CountryGirl Posted January 14, 2010 Author Share Posted January 14, 2010 Okay, well I figured out the PuTTY some. The command you gave when I type it in (with my db info in it) says "command not found." ??????? Thanks! Qadoshyah Quote Link to comment https://forums.phpfreaks.com/topic/188389-need-help-importing-a-database-to-mysqlphpmyadmin/#findComment-995097 Share on other sites More sharing options...
CountryGirl Posted January 14, 2010 Author Share Posted January 14, 2010 I'm able to login to my DB and everything with PuTTY. But, I'm lost as to how to import the DB I need to import. I exported from the previous server and have that zipped SQL file uploaded to my website host with my FTP program. How do I get that file to import into the new DB using Shell access? The mysqldump doesn't seem to be working and I'm not sure why. I must be doing something wrong. Do I need MySQL or something on my computer? I wouldn't think so, but what am I doing wrong?! Thanks! Qadoshyah Quote Link to comment https://forums.phpfreaks.com/topic/188389-need-help-importing-a-database-to-mysqlphpmyadmin/#findComment-995110 Share on other sites More sharing options...
trq Posted January 14, 2010 Share Posted January 14, 2010 The command would be.... mysql -p db_name < backup-file.sql Quote Link to comment https://forums.phpfreaks.com/topic/188389-need-help-importing-a-database-to-mysqlphpmyadmin/#findComment-995168 Share on other sites More sharing options...
trq Posted January 14, 2010 Share Posted January 14, 2010 Oh, but you'll need to make the database first. Type... mysql -p then at the prompt type... create database db_name Quote Link to comment https://forums.phpfreaks.com/topic/188389-need-help-importing-a-database-to-mysqlphpmyadmin/#findComment-995169 Share on other sites More sharing options...
CountryGirl Posted January 15, 2010 Author Share Posted January 15, 2010 Thanks, I'll have to give that a try . Qadoshyah Quote Link to comment https://forums.phpfreaks.com/topic/188389-need-help-importing-a-database-to-mysqlphpmyadmin/#findComment-995666 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.