how to restore a mysql database whit SSH?

**DeiVid** · October 23rd, 2004, 12:22 AM

Hi, i need to restore a database in my server(i love how that sounds, MY SERVER)

well, i need to restore a database in my server, is a *.sql file, but it is to big to do it trough PhpMyAdmin.. so i need to do it trough SSh but i dont know how..

anyone knows?

thnaks...

**patrickb** · October 27th, 2004, 10:33 PM

Simple enough.. Make sure the database is already created and empty (depending on what is in the sql file). If it isn't empty, the easiest thing to do is to type:

mysqladmin drop databasename
mysqladmin create databasename

After that is done, then type:

mysql databasename < file.sql

Of course, replace databasename with the real name of the database and file.sql with the filename (full path if you aren't in the current directory of it).

October 23rd, 2004, 12:22 AM	#1 (permalink)
DeiVid Surpass Fan Comfy Contributor Joined in May 2004 Lives in Viña del Mar, Chile 142 posts Gave thanks: 0 Thanked 0 times	how to restore a mysql database whit SSH? Hi, i need to restore a database in my server(i love how that sounds, MY SERVER) well, i need to restore a database in my server, is a *.sql file, but it is to big to do it trough PhpMyAdmin.. so i need to do it trough SSh but i dont know how.. anyone knows? thnaks... __________________ Surpass Dedicated P.D.: My english sucks.., dont blame me for the incoherents words..

October 27th, 2004, 10:33 PM	#2 (permalink)
patrickb the one who was Super #1 Joined in Jul 2003 Lives in Memphis 1,967 posts Gave thanks: 0 Thanked 3 times	Simple enough.. Make sure the database is already created and empty (depending on what is in the sql file). If it isn't empty, the easiest thing to do is to type: mysqladmin drop databasename mysqladmin create databasename After that is done, then type: mysql databasename < file.sql Of course, replace databasename with the real name of the database and file.sql with the filename (full path if you aren't in the current directory of it). __________________ Patrick Warnings: The program(s) might crash unexpectedly or behave otherwise strangely. (But of course, so do many commercial programs on Windows.) --www.gimp.org

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)