How do I split my database?

So i have made a backup datebase file of my forums. Its 3.8 mb big. I am using WAMP offline to try to use it but the maximum upload file size in the "import" under PHPMYADMIN is only 2mb.

Either A) I need to know how to make it bigger than that or

B) How do I split my database file easily? I've done it manually before but is there an automated way to do this without breaking the tables incorrectly?

 

if its local, there's 0 need to even upload it... its already there.

just go to the mysql command prompt and run the correct import query (google ssh mysql import)


you might be able to change your php.ini max_upload_size paramater to allow phpmyadmin to upload larger files... not sure how this works on windows though.

 

I need more info on this one...

 

Where is the backup? On a remote box? Can you ssh into the box?

 

The backup is on my PC. I have no idea waht SSH is , i'm using WAMP try the database file backup on my pc.

 

So it's all local? And you have a .sql backup file from MySQL?

If so, run from the command prompt: mysql DATABASE_NAME < backupfile.sql

Or get the MySQL GUI tools from mysql.com and do restore the database using MySQL Administrator.

 

I want to ask another related question. How can I copy the database content to another database ?

 

You'll want to do a backup then a restore like akasixcon has done. You can restore it to any database.

I'd get the MySQL Administrator GUI to make it easy.

 

prophecy, Thanks. I want to make all database the same with 50 users, how can I do it in linux command line mode ?

 

backup:
> mysqldump DB_NAME > DB_NAME.sql

load:
> mysql DB_NAME < DB_NAME.sql

 

hi, prophecy, I received error message as below:

mysqldump: Got error: 1045: Access denied for user 'd001'@'localhost' (using pas sword: NO) when trying to connect

 

mysqldump -u YOUR_MYSQL_USERNAME_THAT_HAS_ACCESS_TO_DB_NAME -pYOURPASSWORD DB_NAME > DB_NAME.sql