Menu
▾
▴
webadmin-list
|
From: <da...@so...> - 2006-02-22 23:03:12
|
I forgot to include this is a new install, webmin 1.260 on Slackware 10.2 with MySQL 4.1.14 From: da...@so... To: web...@li... Priority: normal Subject: [webmin-l] New to MySQL Send reply to: web...@li... <mailto:web...@li...?subject=unsubscribe> <mailto:web...@li...?subject=subscribe> Date sent: Wed, 22 Feb 2006 16:48:40 -0600 Hi, Probably something simple. I can't seem to get MySQL server to run. When I click the start server button it grinds for a short bit then comes back to the start server. I feel like a chicken or egg problem here as the start button refers "Click this button to start the MySQL database server on your system with the command cd /usr ; (/usr/bin/safe_mysqld || /usr/bin/mysqld_safe) &. This Webmin module cannot administer the database until it is started. " ************************************************** The host error log reads: 060222 16:33:18 mysqld started 060222 16:33:18 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... 060222 16:33:18 InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 0 43634. InnoDB: Doing recovery: scanned up to log sequence number 0 43634 060222 16:33:18 InnoDB: Flushing modified pages from the buffer pool... 060222 16:33:18 InnoDB: Started; log sequence number 0 43634 060222 16:33:18 [ERROR] Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 060222 16:33:18 mysqld ended |
|
From: Jamie C. <jca...@we...> - 2006-02-23 04:49:43
|
Hi Dan, You should check if MySQL actually gets started or not.. The problem may = be that it really is running, but Webmin doesn't detect it properly. If i= t is running, you should see a process called 'mysqld'. - Jamie -----Original Message----- From: da...@so... Subj: Re: [webmin-l] New to MySQL Date: Thu 23 Feb 2006 9:22 am Size: 2K To: da...@so..., web...@li... I forgot to include this is a new install, webmin 1.260 on Slackware=20 10.2 with MySQL 4.1.14 From: da...@so... To: web...@li... Priority: normal Subject: [webmin-l] New to MySQL Send reply to: web...@li... <mailto:web...@li...?subject=3Dunsubscrib= e> <mailto:web...@li...?subject=3Dsubscribe> Date sent: Wed, 22 Feb 2006 16:48:40 -0600 Hi, Probably something simple. I can't seem to get MySQL server to=20 run. When I click the start server button it grinds for a short bit then=20 comes back to the start server.=20 I feel like a chicken or egg problem here as the start button refers=20 "Click this button to start the MySQL database server on your=20 system with the command cd /usr ;=20 (/usr/bin/safe_mysqld || /usr/bin/mysqld_safe) &.=20 This Webmin module cannot administer the database until it is=20 started. " ************************************************** The host error log reads: 060222 16:33:18 mysqld started=20 060222 16:33:18 InnoDB: Database was not shut down=20 normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the=20 doublewrite InnoDB: buffer...=20 060222 16:33:18 InnoDB: Starting log scan based on=20 checkpoint at InnoDB: log sequence number 0 43634. InnoDB: Doing recovery: scanned up to log sequence number=20 0 43634 060222 16:33:18 InnoDB: Flushing modified pages from the=20 buffer pool...=20 060222 16:33:18 InnoDB: Started; log sequence number 0=20 43634=20 060222 16:33:18 [ERROR] Fatal error: Can't open privilege=20 tables: Table 'mysql.host' doesn't exist=20 060222 16:33:18 mysqld ended=20 ------------------------------------------------------- This SF.Net email is sponsored by xPML, a groundbreaking scripting langua= ge that extends applications into web and mobile media. Attend the live webc= ast and join the prime developer group breaking into this new coding territor= y! http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=3D110944&bid=3D241720&dat=3D= 121642 - Forwarded by the Webmin mailing list at web...@li....n= et To remove yourself from this list, go to http://lists.sourceforge.net/lists/listinfo/webadmin-list --- message truncated --- |
|
From: <da...@so...> - 2006-02-23 15:08:11
|
Hi Jamie, Actually MySQL isn't running, it shuts down even on system reboot. Below are the last two error log entries. The second is after I deleted the databases as in a new start. This is a new install so MySQL hasn't run yet. ****************************************************************************** 060223 08:36:00 mysqld started 060223 8:36:01 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... 060223 8:36:01 InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 0 43634. InnoDB: Doing recovery: scanned up to log sequence number 0 43634 060223 8:36:02 InnoDB: Flushing modified pages from the buffer pool... 060223 8:36:02 InnoDB: Started; log sequence number 0 43634 060223 8:36:02 [ERROR] Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 060223 08:36:02 mysqld ended 060223 08:59:38 mysqld started InnoDB: The first specified data file ./ibdata1 did not exist: InnoDB: a new database to be created! 060223 8:59:39 InnoDB: Setting file ./ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 060223 8:59:39 InnoDB: Log file ./ib_logfile0 did not exist: new to be created InnoDB: Setting log file ./ib_logfile0 size to 5 MB InnoDB: Database physically writes the file full: wait... 060223 8:59:39 InnoDB: Log file ./ib_logfile1 did not exist: new to be created InnoDB: Setting log file ./ib_logfile1 size to 5 MB InnoDB: Database physically writes the file full: wait... InnoDB: Doublewrite buffer not found: creating new InnoDB: Doublewrite buffer created InnoDB: Creating foreign key constraint system tables InnoDB: Foreign key constraint system tables created 060223 8:59:40 InnoDB: Started; log sequence number 0 0 060223 8:59:40 [ERROR] Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 060223 08:59:40 mysqld ended ************************************************************************************************ To: web...@li... Subject: Re: [webmin-l] New to MySQL From: "Jamie Cameron" <jca...@we...> Send reply to: web...@li... <mailto:web...@li...?subject=unsubscribe> <mailto:web...@li...?subject=subscribe> Date sent: Thu, 23 Feb 2006 15:47:00 1100 [ Double-click this line for list subscription options ] Hi Dan, You should check if MySQL actually gets started or not.. The problem may be that it really is running, but Webmin doesn't detect it properly. If it is running, you should see a process called 'mysqld'. - Jamie -----Original Message----- From: da...@so... Subj: Re: [webmin-l] New to MySQL Date: Thu 23 Feb 2006 9:22 am Size: 2K To: da...@so..., web...@li... I forgot to include this is a new install, webmin 1.260 on Slackware 10.2 with MySQL 4.1.14 From: da...@so... To: web...@li... Priority: normal Subject: [webmin-l] New to MySQL Send reply to: web...@li... <mailto:web...@li...?subject=unsubscribe> <mailto:web...@li...?subject=subscribe> Date sent: Wed, 22 Feb 2006 16:48:40 -0600 Hi, Probably something simple. I can't seem to get MySQL server to run. When I click the start server button it grinds for a short bit then comes back to the start server. I feel like a chicken or egg problem here as the start button refers "Click this button to start the MySQL database server on your system with the command cd /usr ; (/usr/bin/safe_mysqld || /usr/bin/mysqld_safe) &. This Webmin module cannot administer the database until it is started. " ************************************************** The host error log reads: 060222 16:33:18 mysqld started 060222 16:33:18 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... 060222 16:33:18 InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 0 43634. InnoDB: Doing recovery: scanned up to log sequence number 0 43634 060222 16:33:18 InnoDB: Flushing modified pages from the buffer pool... 060222 16:33:18 InnoDB: Started; log sequence number 0 43634 060222 16:33:18 [ERROR] Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 060222 16:33:18 mysqld ended ------------------------------------------------------- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642 - Forwarded by the Webmin mailing list at web...@li... To remove yourself from this list, go to http://lists.sourceforge.net/lists/listinfo/webadmin-list --- message truncated --- ------------------------------------------------------- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd- Forwarded by the Webmin mailing list at web...@li... To remove yourself from this list, go to http://lists.sourceforge.net/lists/listinfo/webadmin-list |
|
From: John H. <web...@ew...> - 2006-02-23 16:08:32
|
da...@so... wrote: > Hi Jamie, > Actually MySQL isn't running, it shuts down even on system reboot. > Below are the last two error log entries. The second is after I > deleted the databases as in a new start. This is a new install so > MySQL hasn't run yet. You have deleted or not created the master 'mysql' database which contains all the connection information for any other existing databases. The line, 'mysql.host' would be the host table in the mysql database. This one contains info about what host are allowed to connect to mysql. So there's no method for mysql to connect to itself. This database holds host, user, db, and most of the time columns_priv, func, tables_priv. Each of these instruct mysql as to what databases exist and what who can do from where with them. The basic addressing and permission system. I don't think there are any direct methods within Webmin to create this database. I'm thinking you're going to need to go back through your installation of mysql and find out where/how this database gets created based on your particular installation method (packaged, compiled, etc.). Sounds like a mysql question instead of a Webmin question at this point as this would be a botched install of mysql or at least an incomplete install. Best, John Hinton > > ****************************************************************************** > 060223 08:36:00 mysqld started > 060223 8:36:01 InnoDB: Database was not shut down normally! > InnoDB: Starting crash recovery. > InnoDB: Reading tablespace information from the .ibd files... > InnoDB: Restoring possible half-written data pages from the doublewrite > InnoDB: buffer... > 060223 8:36:01 InnoDB: Starting log scan based on checkpoint at > InnoDB: log sequence number 0 43634. > InnoDB: Doing recovery: scanned up to log sequence number 0 43634 > 060223 8:36:02 InnoDB: Flushing modified pages from the buffer pool... > 060223 8:36:02 InnoDB: Started; log sequence number 0 43634 > 060223 8:36:02 [ERROR] Fatal error: Can't open privilege tables: > Table 'mysql.host' doesn't exist > 060223 08:36:02 mysqld ended > > 060223 08:59:38 mysqld started > InnoDB: The first specified data file ./ibdata1 did not exist: > InnoDB: a new database to be created! > 060223 8:59:39 InnoDB: Setting file ./ibdata1 size to 10 MB > InnoDB: Database physically writes the file full: wait... > 060223 8:59:39 InnoDB: Log file ./ib_logfile0 did not exist: new to > be created > InnoDB: Setting log file ./ib_logfile0 size to 5 MB > InnoDB: Database physically writes the file full: wait... > 060223 8:59:39 InnoDB: Log file ./ib_logfile1 did not exist: new to > be created > InnoDB: Setting log file ./ib_logfile1 size to 5 MB > InnoDB: Database physically writes the file full: wait... > InnoDB: Doublewrite buffer not found: creating new > InnoDB: Doublewrite buffer created > InnoDB: Creating foreign key constraint system tables > InnoDB: Foreign key constraint system tables created > 060223 8:59:40 InnoDB: Started; log sequence number 0 0 > 060223 8:59:40 [ERROR] Fatal error: Can't open privilege tables: > Table 'mysql.host' doesn't exist > 060223 08:59:40 mysqld ended > > ************************************************************************************************ > > To: web...@li... > *Subject: **Re: [webmin-l] New to MySQL* > From: "Jamie Cameron" <jca...@we...> > Send reply to: web...@li... > <mailto:web...@li...?subject=unsubscribe> > <mailto:web...@li...?subject=subscribe> > Date sent: Thu, 23 Feb 2006 15:47:00 1100 > > _[ Double-click this line for list subscription options ]_ > > Hi Dan, > You should check if MySQL actually gets started or not.. The problem > may be that it really is running, but Webmin doesn't detect it > properly. If it is running, you should see a > process called 'mysqld'. > > - Jamie > > -----Original Message----- > > From: da...@so... > Subj: Re: [webmin-l] New to MySQL > Date: Thu 23 Feb 2006 9:22 am > Size: 2K > To: da...@so..., web...@li... > > I forgot to include this is a new install, webmin 1.260 on Slackware > 10.2 with MySQL 4.1.14 > > From: da...@so... > To: web...@li... > Priority: normal > Subject: [webmin-l] New to MySQL > Send reply to: web...@li... > <mailto:web...@li...?subject=unsubscribe> > <mailto:web...@li...?subject=subscribe> > Date sent: Wed, 22 Feb 2006 16:48:40 -0600 > > > Hi, > Probably something simple. I can't seem to get MySQL server to > run. When I click the start server button it grinds for a short bit then > comes back to the start server. > > I feel like a chicken or egg problem here as the start button refers > "Click this button to start the MySQL database server on your > system with the command cd /usr ; > (/usr/bin/safe_mysqld || /usr/bin/mysqld_safe) &. > This Webmin module cannot administer the database until it is > started. " > ************************************************** > The host error log reads: > 060222 16:33:18 mysqld started > 060222 16:33:18 InnoDB: Database was not shut down > normally! > InnoDB: Starting crash recovery. > InnoDB: Reading tablespace information from the .ibd files... > InnoDB: Restoring possible half-written data pages from the > doublewrite > InnoDB: buffer... > 060222 16:33:18 InnoDB: Starting log scan based on > checkpoint at > InnoDB: log sequence number 0 43634. > InnoDB: Doing recovery: scanned up to log sequence number > 0 43634 > 060222 16:33:18 InnoDB: Flushing modified pages from the > buffer pool... > 060222 16:33:18 InnoDB: Started; log sequence number 0 > 43634 > 060222 16:33:18 [ERROR] Fatal error: Can't open privilege > tables: Table 'mysql.host' doesn't exist > 060222 16:33:18 mysqld ended > > > > > ------------------------------------------------------- > This SF.Net email is sponsored by xPML, a groundbreaking scripting > language > that extends applications into web and mobile media. Attend the live > webcast > and join the prime developer group breaking into this new coding > territory! > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642 > - > Forwarded by the Webmin mailing list at > web...@li... > To remove yourself from this list, go to > http://lists.sourceforge.net/lists/listinfo/webadmin-list > > > --- message truncated --- > > > > > ------------------------------------------------------- > This SF.Net email is sponsored by xPML, a groundbreaking scripting > language > that extends applications into web and mobile media. Attend the live > webcast > and join the prime developer group breaking into this new coding > territory! > http://sel.as-us.falkag.net/sel?cmd- > Forwarded by the Webmin mailing list at > web...@li... > To remove yourself from this list, go to > http://lists.sourceforge.net/lists/listinfo/webadmin-list > !DSPAM:43fdd01a147262127750296! |
|
From: <da...@so...> - 2006-02-23 16:50:35
|
Thanks John, That's what I figured but was trying to find an easier way out ;-) This has been from the get go, so I imagine it's the package. From: John Hinton <web...@ew...> To: web...@li... Subject: Re: [webmin-l] New to MySQL Send reply to: web...@li... <mailto:web...@li...?subject=unsubscribe> <mailto:web...@li...?subject=subscribe> Date sent: Thu, 23 Feb 2006 11:07:57 -0500 [ Double-click this line for list subscription options ] da...@so... wrote: > Hi Jamie, > Actually MySQL isn't running, it shuts down even on system reboot. > Below are the last two error log entries. The second is after I > deleted the databases as in a new start. This is a new install so > MySQL hasn't run yet. You have deleted or not created the master 'mysql' database which contains all the connection information for any other existing databases. The line, 'mysql.host' would be the host table in the mysql database. This one contains info about what host are allowed to connect to mysql. So there's no method for mysql to connect to itself. This database holds host, user, db, and most of the time columns_priv, func, tables_priv. Each of these instruct mysql as to what databases exist and what who can do from where with them. The basic addressing and permission system. I don't think there are any direct methods within Webmin to create this database. I'm thinking you're going to need to go back through your installation of mysql and find out where/how this database gets created based on your particular installation method (packaged, compiled, etc.). Sounds like a mysql question instead of a Webmin question at this point as this would be a botched install of mysql or at least an incomplete install. Best, John Hinton > > ****************************************************************************** > 060223 08:36:00 mysqld started > 060223 8:36:01 InnoDB: Database was not shut down normally! > InnoDB: Starting crash recovery. > InnoDB: Reading tablespace information from the .ibd files... > InnoDB: Restoring possible half-written data pages from the doublewrite > InnoDB: buffer... > 060223 8:36:01 InnoDB: Starting log scan based on checkpoint at > InnoDB: log sequence number 0 43634. > InnoDB: Doing recovery: scanned up to log sequence number 0 43634 > 060223 8:36:02 InnoDB: Flushing modified pages from the buffer pool... > 060223 8:36:02 InnoDB: Started; log sequence number 0 43634 > 060223 8:36:02 [ERROR] Fatal error: Can't open privilege tables: > Table 'mysql.host' doesn't exist > 060223 08:36:02 mysqld ended > > 060223 08:59:38 mysqld started > InnoDB: The first specified data file ./ibdata1 did not exist: > InnoDB: a new database to be created! > 060223 8:59:39 InnoDB: Setting file ./ibdata1 size to 10 MB > InnoDB: Database physically writes the file full: wait... > 060223 8:59:39 InnoDB: Log file ./ib_logfile0 did not exist: new to > be created > InnoDB: Setting log file ./ib_logfile0 size to 5 MB > InnoDB: Database physically writes the file full: wait... > 060223 8:59:39 InnoDB: Log file ./ib_logfile1 did not exist: new to > be created > InnoDB: Setting log file ./ib_logfile1 size to 5 MB > InnoDB: Database physically writes the file full: wait... > InnoDB: Doublewrite buffer not found: creating new > InnoDB: Doublewrite buffer created > InnoDB: Creating foreign key constraint system tables > InnoDB: Foreign key constraint system tables created > 060223 8:59:40 InnoDB: Started; log sequence number 0 0 > 060223 8:59:40 [ERROR] Fatal error: Can't open privilege tables: > Table 'mysql.host' doesn't exist > 060223 08:59:40 mysqld ended > > ************************************************************************************************ > > To: web...@li... > *Subject: **Re: [webmin-l] New to MySQL* > From: "Jamie Cameron" <jca...@we...> > Send reply to: web...@li... > <mailto:web...@li...?subject=unsubscribe> > <mailto:web...@li...?subject=subscribe> > Date sent: Thu, 23 Feb 2006 15:47:00 1100 > > _[ Double-click this line for list subscription options ]_ > > Hi Dan, > You should check if MySQL actually gets started or not.. The problem > may be that it really is running, but Webmin doesn't detect it > properly. If it is running, you should see a > process called 'mysqld'. > > - Jamie > > -----Original Message----- > > From: da...@so... > Subj: Re: [webmin-l] New to MySQL > Date: Thu 23 Feb 2006 9:22 am > Size: 2K > To: da...@so..., web...@li... > > I forgot to include this is a new install, webmin 1.260 on Slackware > 10.2 with MySQL 4.1.14 > > From: da...@so... > To: web...@li... > Priority: normal > Subject: [webmin-l] New to MySQL > Send reply to: web...@li... > <mailto:web...@li...?subject=unsubscribe> > <mailto:web...@li...?subject=subscribe> > Date sent: Wed, 22 Feb 2006 16:48:40 -0600 > > > Hi, > Probably something simple. I can't seem to get MySQL server to > run. When I click the start server button it grinds for a short bit then > comes back to the start server. > > I feel like a chicken or egg problem here as the start button refers > "Click this button to start the MySQL database server on your > system with the command cd /usr ; > (/usr/bin/safe_mysqld || /usr/bin/mysqld_safe) &. > This Webmin module cannot administer the database until it is > started. " > ************************************************** > The host error log reads: > 060222 16:33:18 mysqld started > 060222 16:33:18 InnoDB: Database was not shut down > normally! > InnoDB: Starting crash recovery. > InnoDB: Reading tablespace information from the .ibd files... > InnoDB: Restoring possible half-written data pages from the > doublewrite > InnoDB: buffer... > 060222 16:33:18 InnoDB: Starting log scan based on > checkpoint at > InnoDB: log sequence number 0 43634. > InnoDB: Doing recovery: scanned up to log sequence number > 0 43634 > 060222 16:33:18 InnoDB: Flushing modified pages from the > buffer pool... > 060222 16:33:18 InnoDB: Started; log sequence number 0 > 43634 > 060222 16:33:18 [ERROR] Fatal error: Can't open privilege > tables: Table 'mysql.host' doesn't exist > 060222 16:33:18 mysqld ended > > > > > ------------------------------------------------------- > This SF.Net email is sponsored by xPML, a groundbreaking scripting > language > that extends applications into web and mobile media. Attend the live > webcast > and join the prime developer group breaking into this new coding > territory! > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642 > - > Forwarded by the Webmin mailing list at > web...@li... > To remove yourself from this list, go to > http://lists.sourceforge.net/lists/listinfo/webadmin-list > > > --- message truncated --- > > > > > ------------------------------------------------------- > This SF.Net email is sponsored by xPML, a groundbreaking scripting > language > that extends applications into web and mobile media. Attend the live > webcast > and join the prime developer group breaking into this new coding > territory! > http://sel.as-us.falkag.net/sel?cmd- > Forwarded by the Webmin mailing list at > web...@li... > To remove yourself from this list, go to > http://lists.sourceforge.net/lists/listinfo/webadmin-list > !DSPAM:43fdd01a147262127750296! ------------------------------------------------------- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as- us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642 - Forwarded by the Webmin mailing list at webadmin- li...@li... To remove yourself from this list, go to http://lists.sourceforge.net/lists/listinfo/webadmin-list |
|
From: <da...@so...> - 2006-02-23 21:30:33
|
Okay, now with a lot of fighting and fussing we have takeoff Houston AKA mysql version 5.0. Next question how do we upload or import a user database without using another third party administration. I know in the configuration there is an import script setup, but nothing shows up in the module. thanks, Dan From: John Hinton <web...@ew...> To: web...@li... Subject: Re: [webmin-l] New to MySQL Send reply to: web...@li... <mailto:web...@li...?subject=unsubscribe> <mailto:web...@li...?subject=subscribe> Date sent: Thu, 23 Feb 2006 11:07:57 -0500 [ Double-click this line for list subscription options ] da...@so... wrote: > Hi Jamie, > Actually MySQL isn't running, it shuts down even on system reboot. > Below are the last two error log entries. The second is after I > deleted the databases as in a new start. This is a new install so > MySQL hasn't run yet. You have deleted or not created the master 'mysql' database which contains all the connection information for any other existing databases. The line, 'mysql.host' would be the host table in the mysql database. This one contains info about what host are allowed to connect to mysql. So there's no method for mysql to connect to itself. This database holds host, user, db, and most of the time columns_priv, func, tables_priv. Each of these instruct mysql as to what databases exist and what who can do from where with them. The basic addressing and permission system. I don't think there are any direct methods within Webmin to create this database. I'm thinking you're going to need to go back through your installation of mysql and find out where/how this database gets created based on your particular installation method (packaged, compiled, etc.). Sounds like a mysql question instead of a Webmin question at this point as this would be a botched install of mysql or at least an incomplete install. Best, John Hinton > > ****************************************************************************** > 060223 08:36:00 mysqld started > 060223 8:36:01 InnoDB: Database was not shut down normally! > InnoDB: Starting crash recovery. > InnoDB: Reading tablespace information from the .ibd files... > InnoDB: Restoring possible half-written data pages from the doublewrite > InnoDB: buffer... > 060223 8:36:01 InnoDB: Starting log scan based on checkpoint at > InnoDB: log sequence number 0 43634. > InnoDB: Doing recovery: scanned up to log sequence number 0 43634 > 060223 8:36:02 InnoDB: Flushing modified pages from the buffer pool... > 060223 8:36:02 InnoDB: Started; log sequence number 0 43634 > 060223 8:36:02 [ERROR] Fatal error: Can't open privilege tables: > Table 'mysql.host' doesn't exist > 060223 08:36:02 mysqld ended > > 060223 08:59:38 mysqld started > InnoDB: The first specified data file ./ibdata1 did not exist: > InnoDB: a new database to be created! > 060223 8:59:39 InnoDB: Setting file ./ibdata1 size to 10 MB > InnoDB: Database physically writes the file full: wait... > 060223 8:59:39 InnoDB: Log file ./ib_logfile0 did not exist: new to > be created > InnoDB: Setting log file ./ib_logfile0 size to 5 MB > InnoDB: Database physically writes the file full: wait... > 060223 8:59:39 InnoDB: Log file ./ib_logfile1 did not exist: new to > be created > InnoDB: Setting log file ./ib_logfile1 size to 5 MB > InnoDB: Database physically writes the file full: wait... > InnoDB: Doublewrite buffer not found: creating new > InnoDB: Doublewrite buffer created > InnoDB: Creating foreign key constraint system tables > InnoDB: Foreign key constraint system tables created > 060223 8:59:40 InnoDB: Started; log sequence number 0 0 > 060223 8:59:40 [ERROR] Fatal error: Can't open privilege tables: > Table 'mysql.host' doesn't exist > 060223 08:59:40 mysqld ended > > ************************************************************************************************ > > To: web...@li... > *Subject: **Re: [webmin-l] New to MySQL* > From: "Jamie Cameron" <jca...@we...> > Send reply to: web...@li... > <mailto:web...@li...?subject=unsubscribe> > <mailto:web...@li...?subject=subscribe> > Date sent: Thu, 23 Feb 2006 15:47:00 1100 > > _[ Double-click this line for list subscription options ]_ > > Hi Dan, > You should check if MySQL actually gets started or not.. The problem > may be that it really is running, but Webmin doesn't detect it > properly. If it is running, you should see a > process called 'mysqld'. > > - Jamie > > -----Original Message----- > > From: da...@so... > Subj: Re: [webmin-l] New to MySQL > Date: Thu 23 Feb 2006 9:22 am > Size: 2K > To: da...@so..., web...@li... > > I forgot to include this is a new install, webmin 1.260 on Slackware > 10.2 with MySQL 4.1.14 > > From: da...@so... > To: web...@li... > Priority: normal > Subject: [webmin-l] New to MySQL > Send reply to: web...@li... > <mailto:web...@li...?subject=unsubscribe> > <mailto:web...@li...?subject=subscribe> > Date sent: Wed, 22 Feb 2006 16:48:40 -0600 > > > Hi, > Probably something simple. I can't seem to get MySQL server to > run. When I click the start server button it grinds for a short bit then > comes back to the start server. > > I feel like a chicken or egg problem here as the start button refers > "Click this button to start the MySQL database server on your > system with the command cd /usr ; > (/usr/bin/safe_mysqld || /usr/bin/mysqld_safe) &. > This Webmin module cannot administer the database until it is > started. " > ************************************************** > The host error log reads: > 060222 16:33:18 mysqld started > 060222 16:33:18 InnoDB: Database was not shut down > normally! > InnoDB: Starting crash recovery. > InnoDB: Reading tablespace information from the .ibd files... > InnoDB: Restoring possible half-written data pages from the > doublewrite > InnoDB: buffer... > 060222 16:33:18 InnoDB: Starting log scan based on > checkpoint at > InnoDB: log sequence number 0 43634. > InnoDB: Doing recovery: scanned up to log sequence number > 0 43634 > 060222 16:33:18 InnoDB: Flushing modified pages from the > buffer pool... > 060222 16:33:18 InnoDB: Started; log sequence number 0 > 43634 > 060222 16:33:18 [ERROR] Fatal error: Can't open privilege > tables: Table 'mysql.host' doesn't exist > 060222 16:33:18 mysqld ended > > > > > ------------------------------------------------------- > This SF.Net email is sponsored by xPML, a groundbreaking scripting > language > that extends applications into web and mobile media. Attend the live > webcast > and join the prime developer group breaking into this new coding > territory! > http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642 > - > Forwarded by the Webmin mailing list at > web...@li... > To remove yourself from this list, go to > http://lists.sourceforge.net/lists/listinfo/webadmin-list > > > --- message truncated --- > > > > > ------------------------------------------------------- > This SF.Net email is sponsored by xPML, a groundbreaking scripting > language > that extends applications into web and mobile media. Attend the live > webcast > and join the prime developer group breaking into this new coding > territory! > http://sel.as-us.falkag.net/sel?cmd- > Forwarded by the Webmin mailing list at > web...@li... > To remove yourself from this list, go to > http://lists.sourceforge.net/lists/listinfo/webadmin-list > !DSPAM:43fdd01a147262127750296! ------------------------------------------------------- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as- us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642 - Forwarded by the Webmin mailing list at webadmin- li...@li... To remove yourself from this list, go to http://lists.sourceforge.net/lists/listinfo/webadmin-list |
|
From: Jamie C. <jca...@we...> - 2006-02-23 22:46:22
|
Hi Dan,=20 When you edit a database in Webmin, you should see a Backup Database butt= on at the bottom of the page for creating a .sql format backup.=20 To restore on, you need to use the Execute SQL page, and just execute the= backup .sql file. Unlike some other databases, MySQL doesn't have a spec= ial restore program or backup file format. - Jamie -----Original Message----- From: da...@so... Subj: Re: [webmin-l] New to MySQL Date: Fri 24 Feb 2006 7:49 am Size: 3K To: John Hinton <web...@ew...>,web...@li... Okay, now with a lot of fighting and fussing we have takeoff Houston=20 AKA mysql version 5.0. Next question how do we upload or import a=20 user database without using another third party administration. I=20 know in the configuration there is an import script setup, but nothing=20 shows up in the module. thanks, Dan From: John Hinton <web...@ew...> To: web...@li... Subject: Re: [webmin-l] New to MySQL Send reply to: web...@li... <mailto:web...@li...?subject=3Dunsubscrib= e> <mailto:web...@li...?subject=3Dsubscribe> Date sent: Thu, 23 Feb 2006 11:07:57 -0500 [ Double-click this line for list subscription options ]=20 da...@so... wrote: > Hi Jamie, > Actually MySQL isn't running, it shuts down even on system reboot.=20 > Below are the last two error log entries. The second is after I=20 > deleted the databases as in a new start. This is a new install so=20 > MySQL hasn't run yet. You have deleted or not created the master 'mysql' database which=20 contains all the connection information for any other existing=20 databases. The line, 'mysql.host' would be the host table in the=20 mysql=20 database. This one contains info about what host are allowed to=20 connect=20 to mysql. So there's no method for mysql to connect to itself. This=20 database holds host, user, db, and most of the time columns_priv,=20 func,=20 tables_priv. Each of these instruct mysql as to what databases exist=20 and=20 what who can do from where with them. The basic addressing and=20 permission system. I don't think there are any direct methods within Webmin to create=20 this=20 database. I'm thinking you're going to need to go back through your=20 installation of mysql and find out where/how this database gets=20 created=20 based on your particular installation method (packaged, compiled,=20 etc.).=20 Sounds like a mysql question instead of a Webmin question at this=20 point=20 as this would be a botched install of mysql or at least an incomplete=20 install. Best, John Hinton > > ***********************************************************************= ******* > 060223 08:36:00 mysqld started > 060223 8:36:01 InnoDB: Database was not shut down normally! > InnoDB: Starting crash recovery. > InnoDB: Reading tablespace information from the .ibd files... > InnoDB: Restoring possible half-written data pages from the doublewrite > InnoDB: buffer... > 060223 8:36:01 InnoDB: Starting log scan based on checkpoint at > InnoDB: log sequence number 0 43634. > InnoDB: Doing recovery: scanned up to log sequence number 0 43634 > 060223 8:36:02 InnoDB: Flushing modified pages from the buffer pool..= . > 060223 8:36:02 InnoDB: Started; log sequence number 0 43634 > 060223 8:36:02 [ERROR] Fatal error: Can't open privilege tables:=20 > Table 'mysql.host' doesn't exist > 060223 08:36:02 mysqld ended > > 060223 08:59:38 mysqld started > InnoDB: The first specified data file ./ibdata1 did not exist: > InnoDB: a new database to be created! > 060223 8:59:39 InnoDB: Setting file ./ibdata1 size to 10 MB > InnoDB: Database physically writes the file full: wait... > 060223 8:59:39 InnoDB: Log file ./ib_logfile0 did not exist: new to=20 > be created > InnoDB: Setting log file ./ib_logfile0 size to 5 MB > InnoDB: Database physically writes the file full: wait... > 060223 8:59:39 InnoDB: Log file ./ib_logfile1 did not exist: new to=20 > be created > InnoDB: Setting log file ./ib_logfile1 size to 5 MB > InnoDB: Database physically writes the file full: wait... > InnoDB: Doublewrite buffer not found: creating new --- message truncated --- |
