Need Help with MySQLDumper - Importing a large DB file

[Haplo]

I have a problem using MySQLDumper, read on to find out what happens next!

 

According to this thread, here are some descriptors to help my question get answered more quickly/at all:

 

MySQL version: 5.0.45

 

Warning: mysql_connect() [function.mysql-connect]: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

 

MySQL Error given:

Database connection error:

MySQL says:

 

Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

 

I have a 177MB .sql file I have uploaded via FTP and still have on my computer that I want to import to a given MySQL database, using the provided phpMyAdmin. However, the limit is set to 8MB, which is far too small for my file. Even gzipped, it's 55MB in size. I do not have shell access, so I can't SSH into it (although I haven't asked for SSH access yet, I've only tried using it myself already).

 

I contacted the site once and they mentioned I could increase upload_max_filesize from 8 MB to 64 MB and post_max_filesize as well as upload_limit to 10MB, although I thought post_max_filesize needed to be larger than upload_max filesize. Regardless, I tried that and it still failed. I've contacted them again but haven't heard back. So my final approach has been via MySQLDumper (BigDump was too technical for me to understand), although I get the error when entering information on the configuration screen, seen here. Should I change my hostname? It gives a blank error when using MySQL as the hostname. Basically, I don't know what the error means or how to fix it.

 

I've tried to go by the rules of what to post in a help thread, but I'm new and don't know if I've done it correctly, so please bear with me. A search for MySQLDumper turned up one thread, though it only mentions the problem was solved using it, and fails to mention anything beyond its name.

 

Thanks,

 

Haplo

 

P.S. I really like the entry box re-size feature when creating a post.

[fenway]

And you've read the sticky in the child board already?