RE: Restoring mySQL dump
[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; [/snip] [snip from earlier e-mail] The mySQL version is: 4.0.22 [/snip] Quote from http://dev.mysql.com/doc/mysql/en/create-table.html "As of MySQL 4.1, character column definitions can include a CHARACTER SET attribute to specify the character set and, optionally, a collation for the column. For details, see Chapter 10, Character Set Support. CHARSET is a synonym for CHARACTER SET. CREATE TABLE t (c CHAR(20) CHARACTER SET utf8 COLLATE utf8_bin);" CHARSET is not supported in your version of MySQL -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Restoring mySQL dump
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', `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; -- -- Dumping data for table `db1_attach_quota` -- /*!4 ALTER TABLE `db1_attach_quota` DISABLE KEYS */; LOCK TABLES `db1_attach_quota` WRITE; UNLOCK TABLES; /*!4 ALTER TABLE `db1_attach_quota` ENABLE KEYS */; -- -- Table structure for table `db1_attachments` -- Thank you very much indeed. Best regards. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Restoring mySQL dump
[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_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE="NO_AUTO_VALUE_ON_ZERO" */; 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 backupname.sql? Then maybe we can determine what the syntax error is that is NEAR line 7 [/snip] 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'? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Restoring mySQL dump
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_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE="NO_AUTO_VALUE_ON_ZERO" */; Thanks very much. Best regards, Adrian. [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 backupname.sql? Then maybe we can determine what the syntax error is that is NEAR line 7 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Restoring mySQL dump
[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 backupname.sql? Then maybe we can determine what the syntax error is that is NEAR line 7 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Restoring mySQL dump
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 version is: 4.0.22 And yes I can login to the mySQL command line with the root password. Any suggestions would be much appreciated. Thank you very much. Best regards. 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 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: Access denied for user '[EMAIL PROTECTED]' (Using password: No) What is the correct syntax please? Also, can I create a new database and restore the dump file to it or do I need to use the same database name as before? Thank you very much indeed. Best regards. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Dwayne Hottinger Network Administrator Harrisonburg City Public Schools -- Kind Regards Schalk Neethling Web Developer.Designer.Programmer.President Volume4.Business.Solution.Developers emotionalize.conceptualize.visualize.realize Landlines Tel: +27125468436 Fax: +27125468436 Web email:[EMAIL PROTECTED] Global: www.volume4.com Messenger Yahoo!: v_olume4 AOL: v0lume4 MSN: [EMAIL PROTECTED] We support OpenSource Get Firefox!- The browser reloaded - http://www.mozilla.org/products/firefox/ This message contains information that is considered to be sensitive or confidential and may not be forwarded or disclosed to any other party without the permission of the sender. If you received this message in error, please notify me immediately so that I can correct and delete the original email. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Restoring mySQL dump
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 < backupname > > But I am getting: Access denied for user > '[EMAIL PROTECTED]' (Using password: > YES) > > I have also removed the root password and got: > Access denied for user > '[EMAIL PROTECTED]' (Using password: No) > > What is the correct syntax please? > > Also, can I create a new database and restore the > dump file to it or do I > need to use the same database name as before? > > Thank you very much indeed. > > Best regards. > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > Yahoo! Mail Stay connected, organized, and protected. Take the tour: http://tour.mail.yahoo.com/mailtour.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Restoring mySQL dump
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 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: Access denied for user '[EMAIL PROTECTED]' (Using password: No) What is the correct syntax please? Also, can I create a new database and restore the dump file to it or do I need to use the same database name as before? Thank you very much indeed. Best regards. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Dwayne Hottinger Network Administrator Harrisonburg City Public Schools -- Kind Regards Schalk Neethling Web Developer.Designer.Programmer.President Volume4.Business.Solution.Developers emotionalize.conceptualize.visualize.realize Landlines Tel: +27125468436 Fax: +27125468436 Web email:[EMAIL PROTECTED] Global: www.volume4.com Messenger Yahoo!: v_olume4 AOL: v0lume4 MSN: [EMAIL PROTECTED] We support OpenSource Get Firefox!- The browser reloaded - http://www.mozilla.org/products/firefox/ This message contains information that is considered to be sensitive or confidential and may not be forwarded or disclosed to any other party without the permission of the sender. If you received this message in error, please notify me immediately so that I can correct and delete the original email. Thank you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Restoring mySQL dump
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 < backupname > > But I am getting: Access denied for user '[EMAIL PROTECTED]' (Using password: > YES) > > I have also removed the root password and got: Access denied for user > '[EMAIL PROTECTED]' (Using password: No) > > What is the correct syntax please? > > Also, can I create a new database and restore the dump file to it or do I > need to use the same database name as before? > > Thank you very much indeed. > > Best regards. > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > -- Dwayne Hottinger Network Administrator Harrisonburg City Public Schools -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
