Hello, I just bought a site that uses a database and I am having trouble moving it the my comp. The database is named stats.sql I have tried to back it up to my desktop then restore it on the new account but it allows changes it from stats.sql.gz to statssql.gz. Does any one have any easy ways to do this? Thanks.
Sorry, I didn't understand that bit. Somehow the file is being renamed somewhere...yes? When/where is the renaming happening? It may not be important - may just be the same file with a new name. Have you unzipped the statssql.gz file and viewed it with a text viewer (notepad/wordpad)to see if it contains the database info (should probably contain mysql instructions to create the db then lots of insert instructions) in text form? How are you trying to reload it on the new server? Are you using phpmyadmin? How large is the database in Mb? Sorry for so many questions but they'll all help.
Are you sure the SQL file is not gzipped. Can you open the sql file in textpad and see the actual SQL. I am pretty sure you have selected the gzipping option when backing up your DB. This option compresses it. You should either decompress the Gzipped SQL or backup your DB with Gzip compression disabled.