Alright, here is my dilemma. I have a database that I have moved with the exception of two tables. Each table is about 130mb...and contains posts and private messages. They are possibly the most important part of the database aside from member data. I am moving my forum from one server to another, and when I import my database data on the new server, the import tool allows files up to 50mb to be imported, and so that is my problem, I can't export and import a 130 mb file. Is there anything I can do to solve this, or anyone who would like to help me move my database? I guess if you require money to do such small tasks, I can pay you. I was told I should delete posts, but that is not an option until all other ideas and options have been exhausted and thrown out.

I am guessing her, but this is for a mysql database and the export is in sql right?

++

if yes to above, can you get access to your hosting account with Shell?
or if you are a dedicated or virtual private server owner then you defintely can
use shell.

Shell is one of the best ways to transfer VERY large database files and upload them
to phpmyadmin or directly to the database table.

The shell access is the preferred way to go.

But, if you have no shell access, first examine the sql dump.
If the datas are stored with full inserts, you can easily split up the file in smaller parts.

If not (every datas are packed in 1 bug query), then the easiest thing to do is to install a mysql server on your computer, import the datas, and export them back as full inserts, and split up the files.

Or even easier, if you have still access to something like a phpMyAdmin of the old db, redo an export specifying to use full insert queries.

How exactly do I do this shell thing? I realize maybe this is a dumb question for a webmaster to be asking, but some of this stuff is new to me, so any help is great.

You open a terminal, and use the mysql command included in the mysql server download to connect to a remote server, like this:

The mysql.exe must be called from a dos shell.
Under windows, hit the keys "windows" + r and type "cmd" as the command to run.
This will open the shell.
Navigate to the mysql/bin folder and type the command:

mysql.exe -h hostname -u username -p database_name

Once logged in, you will find a screen like that:

Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.0.44-log Gentoo Linux mysql-5.0.44-r2

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>

And then, you'll be able to copy/paste commands into the client.

Originally Posted by tripy

You open a terminal, and use the mysql command included in the mysql server download to connect to a remote server, like this:

The mysql.exe must be called from a dos shell.
Under windows, hit the keys "windows" + r and type "cmd" as the command to run.
This will open the shell.
Navigate to the mysql/bin folder and type the command:

mysql.exe -h hostname -u username -p database_name

Once logged in, you will find a screen like that:

Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.0.44-log Gentoo Linux mysql-5.0.44-r2

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>

And then, you'll be able to copy/paste commands into the client.

Honestly, I didn't get much of what you said...so maybe it would be possible for me to pay someone to do this for me...honestly...I don't know what a terminal is, don't know where the mysql/bin folder is, so yeah.