Hi,
I am now using the following:
mysql -u root -p dbname backupname.sql
And getting:
ERROR 1064 at line 20: You have an error in your SQL syntax. Check the
manual that corresponds to your MySQL server version for the right syntax to
use near 'DEFAULT CHARSET=latin1' at line 7
The mySQL
[snip]
mysql -u root -p dbname backupname.sql
And getting:
ERROR 1064 at line 20: You have an error in your SQL syntax. Check the
manual that corresponds to your MySQL server version for the right
syntax to
use near 'DEFAULT CHARSET=latin1' at line 7
[/snip]
Can we see the first 10 lines of
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
[snip]
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
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',
[snip]
`user_id` mediumint(8) unsigned NOT NULL default '0',
`group_id` mediumint(8) unsigned NOT NULL default '0',
`quota_type` smallint(2) NOT NULL default '0',
`quota_limit_id` mediumint(8) unsigned NOT NULL default '0',
KEY `quota_type` (`quota_type`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
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:
That is 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
Can you sign -in as root user i.e. Administrator? Using:
mysql -u username -p password?
Dwayne Hottinger wrote:
That is 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
Since I am on Windows, I prefer to use a GUI tool like
SQLyog (www.webyog.com)
Karam
--- Adrian Cooper [EMAIL PROTECTED] wrote:
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
10 matches
Mail list logo
