Database control
Originally Said By: grantr281040
Hi there. I have created my site and a MySql database and it seems to work great during local testing. But when I upload my site, I get an error...Warning: mysql_pconnect(): Can't connect to local MySQL server through socket '/usr/local/mysql-5.0/data/mysql.sock' (2) in /home/content/.../connIG.php on line 9
Fatal error: Can't connect to local MySQL server through socket '/usr/local/mysql-5.0/data/mysql.sock' (2) in /home/content/.../connIG.php on line 9
I assume I have to do some sort of export of the database???? I have no idea where to even start.
Thanks!
Hi Grant,
I only recently started playing with databases and found it quite daunting. I was then pointed by a friend in the direction of SQLyog which is available from
downloads.php and have found it invaluable ever since.
I tried out the free version and very quickly purchased the Pro version - more bells and whistles etc! It connects to your own computer localhost and as many databases on the internet you would wish to. You can also transfer all the info in a database from your local machine to a remote server elsewhere.
I find it absolutely invaluable.
Hope this helps.
David
