OK, I'm not having much success here and getting increasingly worried.
phpMyAdmin is failing to restore it, full stop. It just says 'Can not read file'. Whether it could be an IIS or Windows Server issues I don't know? I've tried restoring the backups that were created using the 'Xoops Backup' module, and also the native phpMyAdmin backups. Neither work. Both say 'Can not read file'.
So I had a go at the command line using what Lazbadger suggested :
He wrote :
mysql -u <db_user> -p <database_name> < file.sql
So I wrote the following at the c:\mysql DOS shell :
mysql -u root -p jurrasic5 cms < Backup_05_04_05_.sql
where root is the user, jurrasic5 the password, cms the name of the database and Backup_05_04_05_.sql the name of the backup file. All it did was display the help pages to me.
Don't worry by the way - we are on an internal intranet that is not connected to the outside world or even another office!So I tried the same from the c:\mysql\bin folder. Same problem. So I copied the backup file into the bin folder and tried again. Same problem.
In other words, it's not working! Where should my backup file be located? I assume the use of '<' tells MySQL to do a backup? If not, how does it know what I am asking it to do?
Lastly, here is a snippet of my backup file from the top. Does it look normal and OK? I can e-mail the whole thing to someone if they want (in case the problem is further down)
# Backup for MySQL
#
# --------------------------------------------------------
#
# Table structure for table `xoops_avatar`
#
CREATE TABLE xoops_avatar (
avatar_id mediumint(8) unsigned NOT NULL auto_increment,
avatar_file varchar(30) NOT NULL default '',
avatar_name varchar(100) NOT NULL default '',
avatar_mimetype varchar(30) NOT NULL default '',
avatar_created int(10) NOT NULL default '0',
avatar_display tinyint(1) unsigned NOT NULL default '0',
avatar_weight smallint(5) unsigned NOT NULL default '0',
avatar_type char(1) NOT NULL default '',
PRIMARY KEY (avatar_id),
KEY avatar_type (avatar_type,avatar_display)
) TYPE=MyISAM;
#
# Dumping data for table `xoops_avatar`
#
INSERT INTO xoops_avatar VALUES (4, 'savt411cb177b93e5.jpeg', 'Han Solo', 'image/pjpeg', 1092399479, 1, 0, 'S');
INSERT INTO xoops_avatar VALUES (2, 'savt411cae8408fb4.jpeg', 'Wolfy', 'image/pjpeg', 1092398724, 1, 0, 'S');
INSERT INTO xoops_avatar VALUES (3, 'savt411cae9d681d2.jpeg', 'Funny_Birds', 'image/pjpeg', 1092398749, 1, 0, 'S');
INSERT INTO xoops_avatar VALUES (5, 'savt411cb186a5610.jpeg', 'Neo1', 'image/pjpeg', 1092399494, 1, 0, 'S');
INSERT INTO xoops_avatar VALUES (6, 'savt411cb19f27394.gif', 'Mr Smith', 'image/gif', 1092399519, 1, 0, 'S');
And on and on and on....
I would REALLY appreciate your help guys. If this backup cannot be restored we've lost a years worth of forum postings, news articles, the lot!
Thanks
Ted