hi there,

i have a vps which has crashed and now have a new build of mysql and server.

the old drive is mounted and i can access all the web files from the old drive an have download the mysql raw files from the var/lib folder.

i uploaded to the new site mysql folder and all the isam tables are there with data however the tables that were in innodb are not. the are listed on the left hand side in phpmyadmin but cannot view the data. can i restore this data at all from these files somehow or can i backup using putty from that mounted folder using a command at all?

many thanks

As long as you still have the mdf file you can copy it to where sql keeps the other database files. I keep mine in D:\SQL\DATA. Then do (using your actual path)

EXEC sp_attach_single_file_db @dbname='yourDb',
    @physname=N'D:\SQL\DATA\yourDb.mdf'

no this is a mysql database not mssql

What happens if you copy the database file to the database folder then stop and retart the mysql service?

can view all myisam tables and data but not the innodb tables

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.