> well, the problem is when you want to run mysql
> tools that run on the shell.
> for example, how would you run mysqldump?
just type mysqldump plus the options you want. where's the problem?
> how will you backup your db?
to save the data into a file use this:
mysqldump --user=USERNAME --pass=PASSWORD --host=SERVERHOST --databases DATABASE > /PATH/FILE.SQL
then later to load the data into a database:
mysql --user=USERNAME --pass=PASSWORD --host=SERVERHOST DATABASE < /PATH/FILE.SQL
note:
- replace all in CAPITAL LETTERS
- the host is "localhost" if its on the same machine that you work on or else it's the IP-adress of it.
- on windoze you use a path like c:\path\to\file.sql
> therefore you need to get a shell.
> how do you get a shell?
you can use whatever operating system shell you like most. I use the GNOME-Terminal. on windoze NT/2K/XP it's "cmd" and I think on win95/98 it's "command".
http://animalliberation.tk http://veganismus.ch
http://maqi.de http://tierrechtskochbuch.de