Armstrong
20-01-2006 21:16:56
I'm trying to back-up and restore my databases using myphpadmin, heres the tutorial i have. I need to know where the shell is
To backup your MySQL database you can
1. Use phpMyAdmin and use the options there to dump the contents to a text file.
2. [bff9afbacbc]From the shell, run this command[/bff9afbacbc] mysqldump --opt -uusername -ppassword -h yourMySQLHostname dbname > filename.sql
To restore your database from a backup
Take that db dump and do cat filename.sql | mysql -uusername -ppassword -h yourMySQLHostname dbname
[bff9afbacbc]what is the shell??[/bff9afbacbc]
ajasax
20-01-2006 21:24:12
[quote9e67c2ce3e="Armstrong"][b9e67c2ce3e]what is the shell??[/b9e67c2ce3e][/quote9e67c2ce3e]
It's the "console", the "command-line", "bash", whatever you wanna call it. It depends on what OS you're installing on...
Armstrong
20-01-2006 21:25:12
im on dreamhost, trying to pull a database from one account to another. are you familiar with dreamhost?
ajasax
20-01-2006 21:28:38
[quote964947e7ac="Armstrong"]im on dreamhost, trying to pull a database from one account to another. are you familiar with dreamhost?[/quote964947e7ac]
nope not familiar. Okay, saw their site....so they're linux-based. Only if you are given "shell" access you will be able to do those commands.
Edit also see that you get full linux shell access. You prolly need to login via SSH (Secure shell access). Use PuTTY to do that.