uploading a large mySQL database

[dublinbynumbers]

I'm trying to upload a database onto my new medius hosting, but the file seems to be too large to upload on phpmyadmin. What would be the easiest way around this?

[strawberry]

The file you're trying to upload is generally a .sql file - which is a text file that can be opened by any editor. This text file contains SQL commands that add a rows to the database one by one.

Whenever I've been stuck like that, I generally copy and past the rows about a thousand at a time in to the text box provided for SQL queries in phpMyAdmin.

Equally, you could open the file in your text editor and break it in to smaller files which you could upload through the interface. Be wary of duplicating your uploads, but if you firstly backup your original and then cut-and-paste in to new files, you should be okay.

[dublinbynumbers]

I thought I might use Bigdump , but I can't seem to work out how to change permissions on the directory. I would need to make make chmod 777 on a Linux based system (on a temporary basis). Any ideas on how to do this?

[blacknight]

Most FTP software includes the option to use CHMOD commands - I know CuteFTP used to have it and most of the other commonly used ones should have the option

[dublinbynumbers]

Not having much joy with bigdump and although cutting and pasting appears uploaded the tables, there were several errors... think it might be time to check out paying someone to do it for me before I go mad. Thanks for the posts.