Need Help

1)In my sql myadmin.When i try to import a .sql backup file,the maximum size allowed is 2 mb.But i want to upload more than that.Please help

 

Do you have ssh access to the server, or are you able to edit any server config files?

You may be able to use a program like Navicat, if you can grant remote access to the server. They have a free 30 day trial, and they also have a free non-commercial version.

http://www.navicat.com/

 

You can use HeidiSQL or use MySQL's source command (the best option) or incease file size limit in PHP to support big sql files upload.

 

edit the serve config file and set upload size.

 

I suggest you using sql dump . Just google it . I have tried it .

 

If it's your server
Dont use free servers, they dong give the normal max file size limit.

 

I am speaking about my own server.Temporarily i am running php on my own computer and i can edit all files

In my first post i said"sql myadmin",it was "phpMyadmin,i was referring to-Sorry

I will post a screenshot too





I have highlighted the problem.I would also like to learn sql dumping.I had seen it in google.They ask me to type some commands including username and pass.Where should i type it

thanks

 

You can do this in phpMyAdmin. Select the database the export then check SQL if this is what you need. Then you will have an .sql file with the db

 

In my previous post I have mentioned all the necessary links. To export database using command line use mysqldump. Syntax will be

shell> mysqldump database_name_to_export > dump_file.sql

Code (markup):