FanaticZine

If you are trying connect to a remote MySQL server and if your MySQL client giving you the error message

Can’t connect to MySQL server on ‘< Host name or IP address >‘ (10060)

Check whether your Public IP is allowed to access server,whether your IP is in the Allowed host list.

If you are trying to restore a large database backup back to  your MySQL Server, You know that phpMyAdmin is NOT the best solution for the task, beacause of it’s execution limitaion settings it will reject your file being executed. So one way to archive this is to use the mysql command prompt interface. the syntaxt to back up your database unsing command links is.

mysql -u {UserName} -p {TargetDatabase} < {SourceDumpFile}

{UserName} = Your Database username

{TargetDatabase}= Your Target Databse

{SourceDumpFile}=  Your  SQL Dump File

once you run the above line correctly. you should be prompt for a password, Enter your database password and continue. (the restoring time  depends on the size of your database, so be patient and a grab a coffee if it’s so large.)

If you are getting the error ERROR 2006 (HY000) at line 447: MySQL server has gone away when you are trying to restore any MySQL backup on your command prompt. Try following

Open the my.ini in C:\Windows\ or mysql/bin/my.cnf on XAMPP installation and modify the max_allowed_packet to  a higher value. (Probably  higher than your backup file size)

Hi, Just wanted to warn about the TINYINT data type on MySQL, just in case if you use TINYINT type with a data length 1, Remember that filed can only hold a one BIT means, the field only can hold 1 OR 0.

Cheers.