my host provider send me my database backup as .opt .frm and .myd how i can convert to .sql as in my other host i dont have access to server/databases/mysql thanks
You can ask your old host to take backup in .sql file or you can also convert it to .sql file. Just install MySQL in your local system and restore the backup which is provided by your host and then take backup again in .sql file. Kailash
isnt any script any other way as when i install server on my pc always give me error when i try to access databases
You are going to have to restore it in mysql, I'm sure with some work you can get a copy working on your pc.
hmm i do it on windows server but it was about 6mb after i take backup as .sql it is 800kb is can be encoding problem or what it close after just 800kb i was using plesk now cpanel
Just restore this 800kb backup on new server and check if it covers all the data else you will need to take backup again. Also, if you still have access to old server you can generate backup from PHPMyAdmin or any other tool provided by your old host. Kailash
i restore the database many tables missing and files are about 10mb can i change font of import can it be problem