asgsoft Posted August 29, 2008 Share Posted August 29, 2008 hey evryone! I am a bit stuck here! I have a cPanel backup of a databse which I am trying to restore. Does anyone know what's the best way to do it? it's a tar.gz file. I tried extracting it but it has .MYD and .MYI and .FRM files. Any ideas on how I can get the data back in sql? Thanks Link to comment https://forums.phpfreaks.com/topic/121909-solved-mysql-backup/ Share on other sites More sharing options...
fenway Posted August 29, 2008 Share Posted August 29, 2008 Isn't here an "upload"? Link to comment https://forums.phpfreaks.com/topic/121909-solved-mysql-backup/#findComment-629041 Share on other sites More sharing options...
asgsoft Posted August 29, 2008 Author Share Posted August 29, 2008 there is! But doing so gives a HUGE error message which doesn't make sense Link to comment https://forums.phpfreaks.com/topic/121909-solved-mysql-backup/#findComment-629149 Share on other sites More sharing options...
awpti Posted August 29, 2008 Share Posted August 29, 2008 Stick the myi/myd and data files in /var/lib/mysql/db_name/ It should pick them up. you'll just have to add permissions to the mysql.user and mysql.db tables. Link to comment https://forums.phpfreaks.com/topic/121909-solved-mysql-backup/#findComment-629319 Share on other sites More sharing options...
fenway Posted August 30, 2008 Share Posted August 30, 2008 Assuming there are myISAM tables Link to comment https://forums.phpfreaks.com/topic/121909-solved-mysql-backup/#findComment-629806 Share on other sites More sharing options...
asgsoft Posted August 30, 2008 Author Share Posted August 30, 2008 That's great! Thanks a lot! it works just fine thanks again Link to comment https://forums.phpfreaks.com/topic/121909-solved-mysql-backup/#findComment-629903 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.