I have a really really large mysql file I wanted to put into another database(for backup in future and testing purposes), but I am not certain how to do it.. what is the easiest way..to copy sql data from one database on a server to another.. when I do it right now it says Error everytime.. (it doesn't specify what type of error..it just says error and that's supposed to help me out with a 3.5mb file..sad..) anyway whats the best way??, anything that can make this process alot easier..and whiche method have you used??
Okie, I figured I would have to do it with secure telent.. there is one problem..however.. I would call my self supreme newbie with telent.. any websites that can help me learn?, better yet do you know the exact command(s) to copy structure and data from one db to another?
First, FTP the sql database to your root directory.
Then, you log on into your account with telnet, and type:
mysql -udb_userid -pdb_user_password --database account_newdb< database_old.sql
where
db_userid is the user name you created for your database
db_user_password is the password of that user
account_newdb is the database you want to populate
and database_old.sql is the database that you uploaded.
I connected to ssh..blah blah blah..
and then typed: \u thedatabasename
then I typed: source dumpfile.sql
and all was well..thank you very much.. I really appreciate your help.
Linear Mode
