Refer to my thread I posted at forum Lx Center , my question was, how do I increase the size of the import file into phpMyAdmin inside Kloxo Panel?

You can see the following screen. The current uploadable file size is Max.8,192KiB. So, you can’t upload big file as like 10MB onwards.

At the forum, Anik answered,

You can restore your database through ssh. Upload the file in your server via ftp. now go to that directory where you uploaded that file. It should be something like

[root@server yourdomain.com]# mysql -p -u root seoblogb_wordpr < backup.sql

Alright, here the thing.

The above command can be executed if you were using Kloxo Admin of which you created a domain.

My problem was I created a domain under Client. This is the best way to install a WordPress blog. You can understand why so if you have gone through the tutorial at this site.

Hence, that the right command for my case in this instant:

Very Important:

To get into mydomain.com through SSH

I uploaded SQL file to the root ( dietsolu_20110424_796.sql – This is my file ).

Update: You can upload mysql file to a folder such as blog.

So, my command of the above would be changed to

cd /home/diettips/dietsolutiontips.com/blog

By Anik: You should first upload the .sql file in your current directory where you are in then run the command. If problem persist try