tabletennisman Posted February 28, 2006 Share Posted February 28, 2006 Could somebody please tell me how to upload my mysql database to my host? I've tried to work it out but can't.Thanks Quote Link to comment https://forums.phpfreaks.com/topic/3789-how-to-upload/ Share on other sites More sharing options...
fenway Posted March 1, 2006 Share Posted March 1, 2006 Upload from what format? Quote Link to comment https://forums.phpfreaks.com/topic/3789-how-to-upload/#findComment-13174 Share on other sites More sharing options...
tabletennisman Posted March 1, 2006 Author Share Posted March 1, 2006 OK, i've got phpmyadmin and have created my database in that. Now i've got a host and i want to upload my database to them.Does this make it clearer? (i'm a noob :( Quote Link to comment https://forums.phpfreaks.com/topic/3789-how-to-upload/#findComment-13183 Share on other sites More sharing options...
wickning1 Posted March 1, 2006 Share Posted March 1, 2006 phpMyAdmin has an export tab that you can access from the database's main structure page. If the target server has phpMyAdmin installed, you can use its import tab to load the data. If that is not a possibility, you can load the data through the command line, reply here and I'll try to instruct you. Quote Link to comment https://forums.phpfreaks.com/topic/3789-how-to-upload/#findComment-13218 Share on other sites More sharing options...
tabletennisman Posted March 1, 2006 Author Share Posted March 1, 2006 Thanks, i got it uploaded but now i got another problem.I've just uploaded my database to my host but can't get my database to come up on the pages. I get this error when i open the page:Warning: mysql_connect(): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in /home/www/tcs.awardspace.com/case. php on line 127Couldn't connect to DBThis is my coding on the 127'th line...$db = mysql_connect ('localhost:3306', 'toowoomba_parts', 'mypassword') or die ('Couldn\'t connect to DB');mysql_select_db ('toowoomba_parts', $db) or die ('Couldn\'t select "parts" DB');Thanks guys! Quote Link to comment https://forums.phpfreaks.com/topic/3789-how-to-upload/#findComment-13265 Share on other sites More sharing options...
fenway Posted March 1, 2006 Share Posted March 1, 2006 I suggest you take a look at the relevant [a href=\"http://dev.mysql.com/doc/refman/5.0/en/can-not-connect-to-server.html\" target=\"_blank\"]refman page[/a]. Hope that helps. Quote Link to comment https://forums.phpfreaks.com/topic/3789-how-to-upload/#findComment-13381 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.