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 Quote Link to comment Share on other sites More sharing options...
fenway Posted August 29, 2008 Share Posted August 29, 2008 Isn't here an "upload"? Quote Link to comment 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 Quote Link to comment 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. Quote Link to comment Share on other sites More sharing options...
fenway Posted August 30, 2008 Share Posted August 30, 2008 Assuming there are myISAM tables Quote Link to comment 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 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.