[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;
[/s
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
[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 @OLD_CHARAC
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
[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
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 versi
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
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
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_databas
