How to upload???

[tabletennisman]

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

[fenway]

Upload from what format?

[tabletennisman]

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 :(

[wickning1]

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.

[tabletennisman]

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 127
Couldn't connect to DB

This 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!

[fenway]

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.