Portal Home > Knowledgebase > Articles Database > how can i restore database by putty
how can i restore database by putty
| Posted by UnKnowN BoY, 03-04-2010, 05:44 AM |
| hi
i have vps
and there are database.sql file in public_html of one account
i wanna restore it in database through putty commands
what's the best and easy command for this ?
|
| Posted by Cirtex, 03-04-2010, 05:54 AM |
| Try
1) create database
2) cd /folderlocation where database is
3) mysql --database=user_databasename < dbbackup.sql
Good luck
|
| Posted by UnKnowN BoY, 03-04-2010, 06:08 AM |
| can u tell me what's mean by database=user_databasename ?
|
| Posted by bentink, 03-04-2010, 06:10 AM |
| It is the name of your database.
|
| Posted by UnKnowN BoY, 03-04-2010, 06:23 AM |
| thx alot
database work fine now
|
| Posted by agustan, 03-04-2010, 08:45 AM |
| Thanks Cirtex for the info about how to restore SQL db via SSH/putty command
I myself usually did the database restore via phpMyAdmin or other SQL GUI tools.
|
| Posted by erectvps, 03-04-2010, 09:52 AM |
| If you are trying to do this and it says "Permssion denied. No password" try using -p and then putting in the password for the MySQL DB when prompted
|
Add to Favourites 
Print this Article
Also Read
