Member Avatar for andydeans

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

  • 2 Contributors
  • 4 Replies
  • 230 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by andydeans
Member Avatar for Reverend Jim

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'
Member Avatar for andydeans

no this is a mysql database not mssql

Member Avatar for Reverend Jim

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

Edited by Reverend Jim
Member Avatar for andydeans

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.