i have a backup of my previous site in tar.gz extension.
however, i found that the files inside are not in .sql but in separate folders for each database and table, with .frm, .MYD, and .MYI extensions.
i don't know where to upload them or how. maybe they have to be uploaded directly to the sql database but i don't have an access to that.
please tell me what to do
Don't unzip them! You aren't supposed to do that.
Re-tar them back!
i have the original tar+gzip file. it still wont work when i try to upload it
Do you still have your old webhost?
If so, go into phpmyadmin, go do a .sql TEXT FILE backup. Not .tar.gz or whatever.
unfortunately, no, the old webhost is gone
Then do you still have the
.tar.gz version of the SQL Backup?
If so, go to phpmyadmin, then SQL, then just load the tar.gz there!
If it's bigger than 10mb, use the bigdump like I suggested above.
Just ignore the .frm & whatever files in the tar.gz!
Just to clear this up, the .frm, .MYD, and .MYI files is the actual data as it's stored on the server. You won't be able to restore that to FriHost...
But, there's one thing you can do: send the files to me and I'll use my testing server to convert them into a .sql file for you. My email address is dansoft [--at--] dansoftaustralia.net. I promise you that I'll delete all your data from my computer as soon as this is done.
If you don't feel comfortable doing that, you'll need to set up your own MySQL and Apache servers and manually import it yourself.
i already emailed you the file