SQL file containing INSERT - need to add USE database

anjanesh · #1 (**permalink**) 01-31-06, 07:15

Hi

I created a .sql file that has many INSERT statements - which resulted in a 220MB file - after zipping its 80MB - I uploaded the file to the server which took some hrs as net speed is low here.

Now I realized that I should have added USE database_name in the first line and then execute in command line using mysql < hugefile.sql
But now that USE database_name isnt there, how can I get the command line tool to execute the sql file for a particular database_name ?

Thanks

jfulton · #2 (**permalink**) 01-31-06, 08:50

You can read the dump file back into the server like this:

Code:

shell> mysql db_name < backup-file.sql

Or like this:

Code:

shell> mysql -e "source /path-to-backup/backup-file.sql" db_name

anjanesh · #3 (**permalink**) 01-31-06, 11:56

But how do I get a sql file to be executed when password is involved ?

Code:

-bash-2.05b$ mysql -u username database_name -p < insert_statements.sql

Will this work ?

jfulton · #4 (**permalink**) 01-31-06, 12:42

Code:

--user=u --password=p

anjanesh · #5 (**permalink**) 01-31-06, 22:43

Ah...I see - thought -u and -p were the only ways possible !
Anyway, it worked even with

Code:

-bash-2.05b$ mysql database_name < insert_statements.sql -u username -p

snorp · #6 (**permalink**) 02-04-06, 05:34

(Deleted – the solution is already presented

)

Weird indeed. Saw no other posts – getting old?

Internet Services

Web Development

Digital Marketing

Consumer Tech