Thursday 28 July 2005 3:04:48 pm
Thanks! I have both phpmyadmin and shell access to mysql. I have been trying various commands in the shell, but it doesnt seem to work. I am really scared of doing something wrong here that could put my existing info at risk (which is why I need the backup to start with). Exactly what is the backup line to use in mysql? alternatively: Is "export" the correct function to use in phpmyadmin, and could someone post a screenshot of the admin screen so I can see how to set the options? btw, this is what I tried in mysql:
>mysql [name of database]-u [username] -p < file.sql
I also tried:
mysqldump [name of database]-u [username] -p < file.sql
In both cases I get error message that the file was not found. I think a clear answer to this would be of benefit to others users who adhere to the same level of ineptitude as myself :-D Yours gratefully, Halvor
|