how to import multi sql file into a database?

hello,

i have a problem and need your help.

i have a big sql file 846MB (wp_222)

i have split it into small (846MB / 20=42.3MB)

and the sql file become wp_222_1,wp_222_2..........wp_222_20.

i want to import these files into a database wp_222 via phpMyadmin.

but there are errors after the import process and not success.

how to solve this problem?

need your help.thanks.

 

what is the error message?

 

hello,

this is the error.

how to fix it?thanks.

 

the table wp_cbnetpo_ping_optimizer doesn't exist, you have to create that table first to be able to insert records.

 

Are you able to just upload the Original large .sql file through SSH? Uploading large .sql files are a pain with phpMydamin I run into this problem every month.

 

hello,

thanks for your answer.

 

hello,

i am using SSH.i just using myPhpAdmin.it is also have problems.

 

sorry,wrong statement.i am not using SSH,just using MyPhpAdmin.ok

 

Every host have different limit to import the database. you said you have very large database then check when you click on import. you will see the limit of importing like 1 mb or 2 mb.
So i suggest you to export your database according to new host myphpadmin uploding limit.
Select multipal database and click export and check the site. If the size dosest meet with new server then check less entries.

If you have problem to import database i will help you importing the database. with few charges.
PM me if you are interested

 

This seems to be a problem with the missing table.
This can happen if the SQL DUMP has just the table data & not the table schema.
So when you take a SQL DUMP , make sure to include the TABLE CREATION query as well.
When you do this , the first thing the database will do is to write the queries to create table schema & then writes the queries for data export.