Have you got this error while you uploading database .sql “You probably tried to upload too large file. Please refer to documentation for ways to workaround this limit.” ??

Not worry, here a few tips for that…but it’s only work when you got ssh access 

Now at the command line type:

myazhax#mysql -u username -password

with your username you use to connect to MySQL, if you are connecting to MySQL from PHP then credentials you use there should work just fine.

mysql> show databases;
+——————–+
| Database           |
+——————–+
| information_schema |
| mysql              |
| myazhax        |
| test               |
+——————–+
4 rows in set (0.00 sec)
Using mysql command line allows to execute queries, so first we need to select database in case there is no such statement in the dump file. It is done with:

mysql> use myazhax;

here `database` is a name of your database.

The last thing you need to do is import dump file, the fastest way is by using command ’source’:

mysql> source /home/web/myazhax.sql

mysql>exit

done!