HI , I have moved my website to a new host and I can't upload all .sql file as it says Anyone can recommend another method ? (database is big)
Try uploading the actual file via FTP, and then open up an SSH session to your server (PuttY is a good SSH client), and do the import via the mysql command line program.
In most cases the max file size phpMyAdmin can handle is 2M. An sql is just a plain text file, break it into smaller files, just make sure to run them in the correct order.
As I have 167mb to load to my database today!! Broken down into quite a few files, but still at 3mb to 10mb a file. Does anyone know if I can use cute ftp to upload? If so, how? Will find out later today if I can get this uploaded.
Sure you can use any FTP client to upload to to your webspace. Then you need to import it into MySQL via the command line.
No SSH here . I should write a script that will get data from one server and move it to another . Also there is another way ... On a MySQL table you do an SQL query: select * from table_name into outfile '/home/user/my_writeable_directory/table1.txt' After this you get only structure for this table and make the table structure on new webserver using phpMyAdmin. Upload table1.txt to the new host . Do an SQL query on the new host : load data local infile '/home/user/table1.txt' into table_name http://www.mysql.com if you get any SQL errors (not tested )