Hi guys just in need of some urgent help.
I dont have a backup of my database (.sql file) but i have all the files and folders from program files/mysql, how do i extract these so i can run them in phpmyadmin on my new server?
Hi guys just in need of some urgent help.
I dont have a backup of my database (.sql file) but i have all the files and folders from program files/mysql, how do i extract these so i can run them in phpmyadmin on my new server?
mysqldump is probably the best method to transer db’s to a different server.
MySQL :: MySQL 5.1 Reference Manual :: 4.5.4 mysqldump
where do i type those commands in? in cmd prompt
Yes, with mysqldump you can type in cmd console of MS Windows. But first I think you have to change the cursor to bin directory of mysql.
Yes Mike, that is the way to go, best and probably the easiest. Ensure you change the curson to /bin directory within mysql. Else everything will fail.