MaRiOsGR
asked on
How to restore MySQL dbs
Hello,
I'm using a shell script that takes backup of all the mysql databases of the webserver by using the utility mysqlhotcopy.
The problem is that I'm rookie, and till now I was getting backups from inside the programs/scripts (like from the administration
panels of the forums or portals etc) and the output was always... something.sql.
But the backups i get from my script are folders with files like :
.frm .myd .myi
How do I restore these?
I'm using a shell script that takes backup of all the mysql databases of the webserver by using the utility mysqlhotcopy.
The problem is that I'm rookie, and till now I was getting backups from inside the programs/scripts (like from the administration
panels of the forums or portals etc) and the output was always... something.sql.
But the backups i get from my script are folders with files like :
.frm .myd .myi
How do I restore these?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thank you guys.
@ellandrd I cant use this programm cause the mysql server accepts only localhost connections and the server that im working is not localy :)
@ellandrd I cant use this programm cause the mysql server accepts only localhost connections and the server that im working is not localy :)
http://dev.mysql.com/downloads/administrator/1.1.html
then connect to the server and choose restore, follow onscreen instructions...
Ellandrd