Hello,
None of these lines describe the problem that you are having with
syntax. Can you give us 5 lines either side of the line that includes
'DEFAULT CHARSET=latin1'?
Yes, here it is:
`user_id` mediumint(8) unsigned NOT NULL default '0',
`group_id` mediumint(8) unsigned NOT NULL default '0',
`quo
Hello,
Yes, here are the first 10 lines:
-- MySQL dump 10.9
--
-- Host: localhostDatabase: account_databasename
-- --
-- Server version 4.1.8-standard
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTE
correct. The password for mysql root is probably not the same as
the
system root.
ddh
Quoting Adrian Cooper <[EMAIL PROTECTED]>:
Hello,
I need to restore a mySQL dump file but cannot find the right syntax.
I have root access and have used:
mysql -u root -p account_databasename < backu
Hello,
I need to restore a mySQL dump file but cannot find the right syntax.
I have root access and have used:
mysql -u root -p account_databasename < backupname
But I am getting: Access denied for user '[EMAIL PROTECTED]' (Using password:
YES)
I have also removed the root password and got: Acces