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 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. 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 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. 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 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 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 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 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 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 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 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 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 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 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
Archived
This topic is now archived and is closed to further replies.