I have been looking for a board like this for a long time. I came upon it by accident today.
I'm using MySQL and am able to backup my database such as filename.sql But I need to restore ALL records in the database, I bought a new HDD.
But HOW does one RESTORE the database from the *.sql file??!!? I heard Telnet into the database...or use shell....then at the prompt type mysql -u USERNAME < /PATH/TO/DUMP.SQL ( from manual)
Question is how do u:
- use telnet commands and what is it.
- if I use shell what is that, same as a dos window and if so
what dir do u go to??!?!?
If I type that command in, from above, where do I type it in, dos?
NO WHERE have I found an easy way to restore DB. There are options to backup database.
Could someone PLEASE tell me how they restored their database. At somepoint somebody had to have done this.
Sorry to be such a pain but this seems to be a very important step and I am very new to this.
thanks alot
🙁
