Interactivetools.com Forum: Older Forums & Discontinued Products: Web Design & Coding (HTML, CSS, JavaScript, etc): mysql dump file

Home: Older Forums & Discontinued Products: Web Design & Coding (HTML, CSS, JavaScript, etc):
mysql dump file - dumb question!

Crankez
User

Jan 11, 2007, 5:38 PM

Post #1 of 2 (3342 views)
Shortcut

mysql dump file - dumb question!	Can't Post

Hello guys... a happy customer here.

I was wondering if some users from this forum can give me a clue about how i can update the tables of my Zen Cart installation database using a mysql dump file located on my FTP. I need execute it but no a clue how i can do that.

Im no really familiar with MySql, always use access and that type of DB.

If anyone can give me a hand i really apreciate it

Shocked

Mike4172
User

Jan 12, 2007, 12:19 PM

Post #2 of 2 (3339 views)
Shortcut

Re: [Crankez] mysql dump file - dumb question! [In reply to]	Can't Post

If you have shell or telnet acess you can use the following command:

Code

mysql -u sadmin -p pass21 Customers < custback.sql

Essentially its broken down like this:

Code

mysql -u [username] -p [password] [database_to_restore] < [backupfile]

Hope that helps.

Regards,
Michael
NEW!Logo and Website Design
Auto Post Date and Expiration
GoForum 2.02
http://www.amscripts.net
SKYPE - michael.amscripts

Search for (options)