SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-27-2008, 09:34 PM
| ||||
| ||||
 LOCK TABLES I am having a devil of a time moving a database from one server to another. My database is one that is in production to support the mediawiki wiki application. This is a Solaris Sparc 10 system using the mysql-max-5.0.20a-solaris10-sparc version. My database name is horsewiki. I execute this: # mysqldump --user root --password=password horsewiki > horsewiki.sql and get this: mysqldump: Got error: 1146: Table 'horsewiki.archive' doesn't exist when using LOCK TABLES I have tried using phpMyAdmin-2.9.0.2. It seems to let me export the database to an SQL file. When I attempt to import it on the other system, I get this: ++++++++ Error There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem ERROR: Unknown Punctuation String @ 494 STR: /> SQL: -- phpMyAdmin SQL Dump -- version 2.9.0.2 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Oct 16, 2006 at 10:00 AM -- Server version: 5.0.20 -- PHP Version: 5.1.6 -- -- Database: `horsewiki` -- <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en" dir="ltr"> <head> <link rel="icon" href="./favicon.ico" type="image/x-icon" /> <link rel="shortcut icon" href="./favicon.ico" type="image/x-icon" /> <title>phpMyAdmin</title> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <link rel="stylesheet" type="text/css" href="./css/phpmyadmin.css.php?token=7c73a56802fc2e39fe41180d7 21&js_frame=right" /> <link rel="stylesheet" type="text/css" href="./css/print.css?token=7c73a56802fc2ee8b4239fe721" media="print" /> <script type="text/javascript" language="javascript"> // <     |
|
02-27-2008, 09:34 PM
| |||
| |||
| Re: LOCK TABLES Michael, is the 'archive' table present in your database? e.g., if you do a 'LIST TABLES', does it show up? What happens if you do a "SELECT * FROM archive LIMIT 1" ? I'd hazard a guess that you may have a table definition file with no actual table data files, if you're on MyISAM tables. If you don't need the archive table, can you DROP it successfully? Dan On 10/16/06, mdpeters <mdpeters@lazarusalliance.com> wrote: > I am having a devil of a time moving a database from one server to > another. My database is one that is in production to support the > mediawiki wiki application. This is a Solaris Sparc 10 system using the > mysql-max-5.0.20a-solaris10-sparc version. My database name is horsewiki. > > I execute this: > # mysqldump --user root --password=password horsewiki > horsewiki.sql > and get this: > mysqldump: Got error: 1146: Table 'horsewiki.archive' doesn't exist when > using LOCK TABLES > > I have tried using phpMyAdmin-2.9.0.2. It seems to let me export the > database to an SQL file. When I attempt to import it on the other > system, I get this: > ++++++++ > Error > > There seems to be an error in your SQL query. The MySQL server error > output below, if there is any, may also help you in diagnosing the problem > > ERROR: Unknown Punctuation String @ 494 > STR: /> > SQL: -- phpMyAdmin SQL Dump > -- version 2.9.0.2 > -- http://www.phpmyadmin.net > -- > -- Host: localhost > -- Generation Time: Oct 16, 2006 at 10:00 AM > -- Server version: 5.0.20 > -- PHP Version: 5.1.6 > -- > -- Database: `horsewiki` > -- > <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" > "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> > <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en" > dir="ltr"> > <head> > <link rel="icon" href="./favicon.ico" type="image/x-icon" /> > <link rel="shortcut icon" href="./favicon.ico" type="image/x-icon" /> > <title>phpMyAdmin</title> > <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> > <link rel="stylesheet" type="text/css" > href="./css/phpmyadmin.css.php?token=7c73a56802fc2e39fe41180d7 21&js_frame=right" > /> > <link rel="stylesheet" type="text/css" > href="./css/print.css?token=7c73a56802fc2ee8b4239fe721" media="print" /> > <script type="text/javascript" language="javascript"> > // <![CDATA[ > // Updates the title of the frameset if possible (ns4 does not allow > this) > if (typeof(parent.document) != 'undefined' && > typeof(parent.document) != 'unknown' > && typeof(parent.document.title) == 'string') { > parent.document.title = 'www.lazarusalliance.com / localhost / > horsewiki / archive | phpMyAdmin 2.9.0.2'; > > > SQL query: > > -- phpMyAdmin SQL Dump -- version 2.9.0.2 -- http://www.phpmyadmin.net > -- -- Host: localhost -- Generation Time: Oct 16, 2006 at 10:00 AM -- > Server version: 5.0.20 -- PHP Version: 5.1.6 -- -- Database: `horsewiki` -- > ++++++++ > > I have not found a good source to understand what the problem might be. > It does not help that I am such a greenhorn with databases either. I > would appreciate any assistance. > > Michael > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=drbuettner@gmail.com > > |
|
02-27-2008, 09:35 PM
| |||
| |||
| Re: LOCK TABLES As you can see, it is clearly showing up but I cannot do anything with it. mysql> show tables; +---------------------+ | Tables_in_horsewiki | +---------------------+ | archive | | categorylinks | | externallinks | | hitcounter | | horse_archive | | horse_categorylinks | | horse_externallinks | | horse_hitcounter | | horse_image | | horse_imagelinks | | horse_interwiki | | horse_ipblocks | | horse_job | | horse_logging | | horse_math | | horse_objectcache | | horse_oldimage | | horse_page | | horse_pagelinks | | horse_querycache | | horse_recentchanges | | horse_revision | | horse_searchindex | | horse_site_stats | | horse_templatelinks | | horse_text | | horse_trackbacks | | horse_transcache | | horse_user | | horse_user_groups | | horse_user_newtalk | | horse_validate | | horse_watchlist | | image | | imagelinks | | interwiki | | ipblocks | | job | | logging | | math | | objectcache | | oldimage | | page | | pagelinks | | querycache | | recentchanges | | revision | | searchindex | | site_stats | | templatelinks | | text | | trackbacks | | transcache | | user | | user_groups | | user_newtalk | | validate | | watchlist | +---------------------+ 58 rows in set (0.00 sec) mysql> SELECT * FROM archive LIMIT 1; ERROR 1146 (42S02): Table 'horsewiki.archive' doesn't exist mysql> drop table archive; ERROR 1051 (42S02): Unknown table 'archive' Dan Buettner wrote: > Michael, is the 'archive' table present in your database? e.g., if > you do a 'LIST TABLES', does it show up? What happens if you do a > "SELECT * FROM archive LIMIT 1" ? > > I'd hazard a guess that you may have a table definition file with no > actual table data files, if you're on MyISAM tables. > > If you don't need the archive table, can you DROP it successfully? > > Dan > > > On 10/16/06, mdpeters <mdpeters@lazarusalliance.com> wrote: > >> I am having a devil of a time moving a database from one server to >> another. My database is one that is in production to support the >> mediawiki wiki application. This is a Solaris Sparc 10 system using the >> mysql-max-5.0.20a-solaris10-sparc version. My database name is >> horsewiki. >> >> I execute this: >> # mysqldump --user root --password=password horsewiki > horsewiki.sql >> and get this: >> mysqldump: Got error: 1146: Table 'horsewiki.archive' doesn't exist when >> using LOCK TABLES >> >> I have tried using phpMyAdmin-2.9.0.2. It seems to let me export the >> database to an SQL file. When I attempt to import it on the other >> system, I get this: >> ++++++++ >> Error >> >> There seems to be an error in your SQL query. The MySQL server error >> output below, if there is any, may also help you in diagnosing the >> problem >> >> ERROR: Unknown Punctuation String @ 494 >> STR: /> >> SQL: -- phpMyAdmin SQL Dump >> -- version 2.9.0.2 >> -- http://www.phpmyadmin.net >> -- >> -- Host: localhost >> -- Generation Time: Oct 16, 2006 at 10:00 AM >> -- Server version: 5.0.20 >> -- PHP Version: 5.1.6 >> -- >> -- Database: `horsewiki` >> -- >> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" >> "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> >> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en" >> dir="ltr"> >> <head> >> <link rel="icon" href="./favicon.ico" type="image/x-icon" /> >> <link rel="shortcut icon" href="./favicon.ico" >> type="image/x-icon" /> >> <title>phpMyAdmin</title> >> <meta http-equiv="Content-Type" content="text/html; >> charset=utf-8" /> >> <link rel="stylesheet" type="text/css" >> href="./css/phpmyadmin.css.php?token=7c73a56802fc2e39fe41180d7 21&js_frame=right" >> >> /> >> <link rel="stylesheet" type="text/css" >> href="./css/print.css?token=7c73a56802fc2ee8b4239fe721" media="print" /> >> <script type="text/javascript" language="javascript"> >> // <![CDATA[ >> // Updates the title of the frameset if possible (ns4 does not allow >> this) >> if (typeof(parent.document) != 'undefined' && >> typeof(parent.document) != 'unknown' >> && typeof(parent.document.title) == 'string') { >> parent.document.title = 'www.lazarusalliance.com / localhost / >> horsewiki / archive | phpMyAdmin 2.9.0.2'; >> >> >> SQL query: >> >> -- phpMyAdmin SQL Dump -- version 2.9.0.2 -- http://www.phpmyadmin.net >> -- -- Host: localhost -- Generation Time: Oct 16, 2006 at 10:00 AM -- >> Server version: 5.0.20 -- PHP Version: 5.1.6 -- -- Database: >> `horsewiki` -- >> ++++++++ >> >> I have not found a good source to understand what the problem might be. >> It does not help that I am such a greenhorn with databases either. I >> would appreciate any assistance. >> >> Michael >> >> -- >> MySQL General Mailing List >> For list archives: http://lists.mysql.com/mysql >> To unsubscribe: >> http://lists.mysql.com/mysql?unsub=drbuettner@gmail.com >> >> |
|
02-27-2008, 09:35 PM
| |||
| |||
| Re: LOCK TABLES Try looking in the filesystem for the file(s) called "archive" in the database directory, and move them somewhere else (or if you know you don't need them, delete them). If it is/was a MyISAM table, or just an errant file, this should work. If it is/was InnoDB, this will be trickier ... Dan On 10/16/06, mdpeters <mdpeters@lazarusalliance.com> wrote: > As you can see, it is clearly showing up but I cannot do anything with it. > > mysql> show tables; > +---------------------+ > | Tables_in_horsewiki | > +---------------------+ > | archive | > | categorylinks | > | externallinks | > | hitcounter | > | horse_archive | > | horse_categorylinks | > | horse_externallinks | > | horse_hitcounter | > | horse_image | > | horse_imagelinks | > | horse_interwiki | > | horse_ipblocks | > | horse_job | > | horse_logging | > | horse_math | > | horse_objectcache | > | horse_oldimage | > | horse_page | > | horse_pagelinks | > | horse_querycache | > | horse_recentchanges | > | horse_revision | > | horse_searchindex | > | horse_site_stats | > | horse_templatelinks | > | horse_text | > | horse_trackbacks | > | horse_transcache | > | horse_user | > | horse_user_groups | > | horse_user_newtalk | > | horse_validate | > | horse_watchlist | > | image | > | imagelinks | > | interwiki | > | ipblocks | > | job | > | logging | > | math | > | objectcache | > | oldimage | > | page | > | pagelinks | > | querycache | > | recentchanges | > | revision | > | searchindex | > | site_stats | > | templatelinks | > | text | > | trackbacks | > | transcache | > | user | > | user_groups | > | user_newtalk | > | validate | > | watchlist | > +---------------------+ > 58 rows in set (0.00 sec) > > mysql> SELECT * FROM archive LIMIT 1; > ERROR 1146 (42S02): Table 'horsewiki.archive' doesn't exist > > mysql> drop table archive; > ERROR 1051 (42S02): Unknown table 'archive' > > > > > Dan Buettner wrote: > > > Michael, is the 'archive' table present in your database? e.g., if > > you do a 'LIST TABLES', does it show up? What happens if you do a > > "SELECT * FROM archive LIMIT 1" ? > > > > I'd hazard a guess that you may have a table definition file with no > > actual table data files, if you're on MyISAM tables. > > > > If you don't need the archive table, can you DROP it successfully? > > > > Dan > > > > > > On 10/16/06, mdpeters <mdpeters@lazarusalliance.com> wrote: > > > >> I am having a devil of a time moving a database from one server to > >> another. My database is one that is in production to support the > >> mediawiki wiki application. This is a Solaris Sparc 10 system using the > >> mysql-max-5.0.20a-solaris10-sparc version. My database name is > >> horsewiki. > >> > >> I execute this: > >> # mysqldump --user root --password=password horsewiki > horsewiki.sql > >> and get this: > >> mysqldump: Got error: 1146: Table 'horsewiki.archive' doesn't exist when > >> using LOCK TABLES > >> > >> I have tried using phpMyAdmin-2.9.0.2. It seems to let me export the > >> database to an SQL file. When I attempt to import it on the other > >> system, I get this: > >> ++++++++ > >> Error > >> > >> There seems to be an error in your SQL query. The MySQL server error > >> output below, if there is any, may also help you in diagnosing the > >> problem > >> > >> ERROR: Unknown Punctuation String @ 494 > >> STR: /> > >> SQL: -- phpMyAdmin SQL Dump > >> -- version 2.9.0.2 > >> -- http://www.phpmyadmin.net > >> -- > >> -- Host: localhost > >> -- Generation Time: Oct 16, 2006 at 10:00 AM > >> -- Server version: 5.0.20 > >> -- PHP Version: 5.1.6 > >> -- > >> -- Database: `horsewiki` > >> -- > >> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" > >> "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> > >> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en" > >> dir="ltr"> > >> <head> > >> <link rel="icon" href="./favicon.ico" type="image/x-icon" /> > >> <link rel="shortcut icon" href="./favicon.ico" > >> type="image/x-icon" /> > >> <title>phpMyAdmin</title> > >> <meta http-equiv="Content-Type" content="text/html; > >> charset=utf-8" /> > >> <link rel="stylesheet" type="text/css" > >> href="./css/phpmyadmin.css.php?token=7c73a56802fc2e39fe41180d7 21&js_frame=right" > >> > >> /> > >> <link rel="stylesheet" type="text/css" > >> href="./css/print.css?token=7c73a56802fc2ee8b4239fe721" media="print" /> > >> <script type="text/javascript" language="javascript"> > >> // <![CDATA[ > >> // Updates the title of the frameset if possible (ns4 does not allow > >> this) > >> if (typeof(parent.document) != 'undefined' && > >> typeof(parent.document) != 'unknown' > >> && typeof(parent.document.title) == 'string') { > >> parent.document.title = 'www.lazarusalliance.com / localhost / > >> horsewiki / archive | phpMyAdmin 2.9.0.2'; > >> > >> > >> SQL query: > >> > >> -- phpMyAdmin SQL Dump -- version 2.9.0.2 -- http://www.phpmyadmin.net > >> -- -- Host: localhost -- Generation Time: Oct 16, 2006 at 10:00 AM -- > >> Server version: 5.0.20 -- PHP Version: 5.1.6 -- -- Database: > >> `horsewiki` -- > >> ++++++++ > >> > >> I have not found a good source to understand what the problem might be. > >> It does not help that I am such a greenhorn with databases either. I > >> would appreciate any assistance. > >> > >> Michael > >> > >> -- > >> MySQL General Mailing List > >> For list archives: http://lists.mysql.com/mysql > >> To unsubscribe: > >> http://lists.mysql.com/mysql?unsub=drbuettner@gmail.com > >> > >> > > |
|
02-27-2008, 09:35 PM
| |||
| |||
| Re: LOCK TABLES I tried mv archive.frm .archive.frm first. Then I ran mysqldump again. It moves past archive and onto another table. I did this 6 times, each time moving the next one it complained about until I stopped and put them all back. Dan Buettner wrote: > Try looking in the filesystem for the file(s) called "archive" in the > database directory, and move them somewhere else (or if you know you > don't need them, delete them). > > If it is/was a MyISAM table, or just an errant file, this should work. > If it is/was InnoDB, this will be trickier ... > > Dan > > > On 10/16/06, mdpeters <mdpeters@lazarusalliance.com> wrote: > >> As you can see, it is clearly showing up but I cannot do anything >> with it. >> >> mysql> show tables; >> +---------------------+ >> | Tables_in_horsewiki | >> +---------------------+ >> | archive | >> | categorylinks | >> | externallinks | >> | hitcounter | >> | horse_archive | >> | horse_categorylinks | >> | horse_externallinks | >> | horse_hitcounter | >> | horse_image | >> | horse_imagelinks | >> | horse_interwiki | >> | horse_ipblocks | >> | horse_job | >> | horse_logging | >> | horse_math | >> | horse_objectcache | >> | horse_oldimage | >> | horse_page | >> | horse_pagelinks | >> | horse_querycache | >> | horse_recentchanges | >> | horse_revision | >> | horse_searchindex | >> | horse_site_stats | >> | horse_templatelinks | >> | horse_text | >> | horse_trackbacks | >> | horse_transcache | >> | horse_user | >> | horse_user_groups | >> | horse_user_newtalk | >> | horse_validate | >> | horse_watchlist | >> | image | >> | imagelinks | >> | interwiki | >> | ipblocks | >> | job | >> | logging | >> | math | >> | objectcache | >> | oldimage | >> | page | >> | pagelinks | >> | querycache | >> | recentchanges | >> | revision | >> | searchindex | >> | site_stats | >> | templatelinks | >> | text | >> | trackbacks | >> | transcache | >> | user | >> | user_groups | >> | user_newtalk | >> | validate | >> | watchlist | >> +---------------------+ >> 58 rows in set (0.00 sec) >> >> mysql> SELECT * FROM archive LIMIT 1; >> ERROR 1146 (42S02): Table 'horsewiki.archive' doesn't exist >> >> mysql> drop table archive; >> ERROR 1051 (42S02): Unknown table 'archive' >> >> >> >> >> Dan Buettner wrote: >> >> > Michael, is the 'archive' table present in your database? e.g., if >> > you do a 'LIST TABLES', does it show up? What happens if you do a >> > "SELECT * FROM archive LIMIT 1" ? >> > >> > I'd hazard a guess that you may have a table definition file with no >> > actual table data files, if you're on MyISAM tables. >> > >> > If you don't need the archive table, can you DROP it successfully? >> > >> > Dan >> > >> > >> > On 10/16/06, mdpeters <mdpeters@lazarusalliance.com> wrote: >> > >> >> I am having a devil of a time moving a database from one server to >> >> another. My database is one that is in production to support the >> >> mediawiki wiki application. This is a Solaris Sparc 10 system >> using the >> >> mysql-max-5.0.20a-solaris10-sparc version. My database name is >> >> horsewiki. >> >> >> >> I execute this: >> >> # mysqldump --user root --password=password horsewiki > horsewiki.sql >> >> and get this: >> >> mysqldump: Got error: 1146: Table 'horsewiki.archive' doesn't >> exist when >> >> using LOCK TABLES >> >> >> >> I have tried using phpMyAdmin-2.9.0.2. It seems to let me export the >> >> database to an SQL file. When I attempt to import it on the other >> >> system, I get this: >> >> ++++++++ >> >> Error >> >> >> >> There seems to be an error in your SQL query. The MySQL server error >> >> output below, if there is any, may also help you in diagnosing the >> >> problem >> >> >> >> ERROR: Unknown Punctuation String @ 494 >> >> STR: /> >> >> SQL: -- phpMyAdmin SQL Dump >> >> -- version 2.9.0.2 >> >> -- http://www.phpmyadmin.net >> >> -- >> >> -- Host: localhost >> >> -- Generation Time: Oct 16, 2006 at 10:00 AM >> >> -- Server version: 5.0.20 >> >> -- PHP Version: 5.1.6 >> >> -- >> >> -- Database: `horsewiki` >> >> -- >> >> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" >> >> "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> >> >> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en" >> >> dir="ltr"> >> >> <head> >> >> <link rel="icon" href="./favicon.ico" type="image/x-icon" /> >> >> <link rel="shortcut icon" href="./favicon.ico" >> >> type="image/x-icon" /> >> >> <title>phpMyAdmin</title> >> >> <meta http-equiv="Content-Type" content="text/html; >> >> charset=utf-8" /> >> >> <link rel="stylesheet" type="text/css" >> >> >> href="./css/phpmyadmin.css.php?token=7c73a56802fc2e39fe41180d7 21&js_frame=right" >> >> >> >> >> /> >> >> <link rel="stylesheet" type="text/css" >> >> href="./css/print.css?token=7c73a56802fc2ee8b4239fe721" >> media="print" /> >> >> <script type="text/javascript" language="javascript"> >> >> // <![CDATA[ >> >> // Updates the title of the frameset if possible (ns4 does not >> allow >> >> this) >> >> if (typeof(parent.document) != 'undefined' && >> >> typeof(parent.document) != 'unknown' >> >> && typeof(parent.document.title) == 'string') { >> >> parent.document.title = 'www.lazarusalliance.com / >> localhost / >> >> horsewiki / archive | phpMyAdmin 2.9.0.2'; >> >> >> >> >> >> SQL query: >> >> >> >> -- phpMyAdmin SQL Dump -- version 2.9.0.2 -- >> http://www.phpmyadmin.net >> >> -- -- Host: localhost -- Generation Time: Oct 16, 2006 at 10:00 AM -- >> >> Server version: 5.0.20 -- PHP Version: 5.1.6 -- -- Database: >> >> `horsewiki` -- >> >> ++++++++ >> >> >> >> I have not found a good source to understand what the problem >> might be. >> >> It does not help that I am such a greenhorn with databases either. I >> >> would appreciate any assistance. >> >> >> >> Michael >> >> >> >> -- >> >> MySQL General Mailing List >> >> For list archives: http://lists.mysql.com/mysql >> >> To unsubscribe: >> >> http://lists.mysql.com/mysql?unsub=drbuettner@gmail.com >> >> >> >> >> >> > |
|
02-27-2008, 09:35 PM
| |||
| |||
| Re: Re: LOCK TABLES Hmmm, sounds like something's pretty abnormal here. Any idea what may have been done here? I wonder if you could step around this with a call to mysqldump that doesn't explicitly lock tables ... what is the commad you're running again? Dan On 10/16/06, mdpeters <mdpeters@lazarusalliance.com> wrote: > I tried mv archive.frm .archive.frm first. Then I ran mysqldump again. > It moves past archive and onto another table. I did this 6 times, each > time moving the next one it complained about until I stopped and put > them all back. > > Dan Buettner wrote: > > > Try looking in the filesystem for the file(s) called "archive" in the > > database directory, and move them somewhere else (or if you know you > > don't need them, delete them). > > > > If it is/was a MyISAM table, or just an errant file, this should work. > > If it is/was InnoDB, this will be trickier ... > > > > Dan > > > > > > On 10/16/06, mdpeters <mdpeters@lazarusalliance.com> wrote: > > > >> As you can see, it is clearly showing up but I cannot do anything > >> with it. > >> > >> mysql> show tables; > >> +---------------------+ > >> | Tables_in_horsewiki | > >> +---------------------+ > >> | archive | > >> | categorylinks | > >> | externallinks | > >> | hitcounter | > >> | horse_archive | > >> | horse_categorylinks | > >> | horse_externallinks | > >> | horse_hitcounter | > >> | horse_image | > >> | horse_imagelinks | > >> | horse_interwiki | > >> | horse_ipblocks | > >> | horse_job | > >> | horse_logging | > >> | horse_math | > >> | horse_objectcache | > >> | horse_oldimage | > >> | horse_page | > >> | horse_pagelinks | > >> | horse_querycache | > >> | horse_recentchanges | > >> | horse_revision | > >> | horse_searchindex | > >> | horse_site_stats | > >> | horse_templatelinks | > >> | horse_text | > >> | horse_trackbacks | > >> | horse_transcache | > >> | horse_user | > >> | horse_user_groups | > >> | horse_user_newtalk | > >> | horse_validate | > >> | horse_watchlist | > >> | image | > >> | imagelinks | > >> | interwiki | > >> | ipblocks | > >> | job | > >> | logging | > >> | math | > >> | objectcache | > >> | oldimage | > >> | page | > >> | pagelinks | > >> | querycache | > >> | recentchanges | > >> | revision | > >> | searchindex | > >> | site_stats | > >> | templatelinks | > >> | text | > >> | trackbacks | > >> | transcache | > >> | user | > >> | user_groups | > >> | user_newtalk | > >> | validate | > >> | watchlist | > >> +---------------------+ > >> 58 rows in set (0.00 sec) > >> > >> mysql> SELECT * FROM archive LIMIT 1; > >> ERROR 1146 (42S02): Table 'horsewiki.archive' doesn't exist > >> > >> mysql> drop table archive; > >> ERROR 1051 (42S02): Unknown table 'archive' > >> > >> > >> > >> > >> Dan Buettner wrote: > >> > >> > Michael, is the 'archive' table present in your database? e.g., if > >> > you do a 'LIST TABLES', does it show up? What happens if you do a > >> > "SELECT * FROM archive LIMIT 1" ? > >> > > >> > I'd hazard a guess that you may have a table definition file with no > >> > actual table data files, if you're on MyISAM tables. > >> > > >> > If you don't need the archive table, can you DROP it successfully? > >> > > >> > Dan > >> > > >> > > >> > On 10/16/06, mdpeters <mdpeters@lazarusalliance.com> wrote: > >> > > >> >> I am having a devil of a time moving a database from one server to > >> >> another. My database is one that is in production to support the > >> >> mediawiki wiki application. This is a Solaris Sparc 10 system > >> using the > >> >> mysql-max-5.0.20a-solaris10-sparc version. My database name is > >> >> horsewiki. > >> >> > >> >> I execute this: > >> >> # mysqldump --user root --password=password horsewiki > horsewiki.sql > >> >> and get this: > >> >> mysqldump: Got error: 1146: Table 'horsewiki.archive' doesn't > >> exist when > >> >> using LOCK TABLES > >> >> > >> >> I have tried using phpMyAdmin-2.9.0.2. It seems to let me export the > >> >> database to an SQL file. When I attempt to import it on the other > >> >> system, I get this: > >> >> ++++++++ > >> >> Error > >> >> > >> >> There seems to be an error in your SQL query. The MySQL server error > >> >> output below, if there is any, may also help you in diagnosing the > >> >> problem > >> >> > >> >> ERROR: Unknown Punctuation String @ 494 > >> >> STR: /> > >> >> SQL: -- phpMyAdmin SQL Dump > >> >> -- version 2.9.0.2 > >> >> -- http://www.phpmyadmin.net > >> >> -- > >> >> -- Host: localhost > >> >> -- Generation Time: Oct 16, 2006 at 10:00 AM > >> >> -- Server version: 5.0.20 > >> >> -- PHP Version: 5.1.6 > >> >> -- > >> >> -- Database: `horsewiki` > >> >> -- > >> >> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" > >> >> "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> > >> >> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en" > >> >> dir="ltr"> > >> >> <head> > >> >> <link rel="icon" href="./favicon.ico" type="image/x-icon" /> > >> >> <link rel="shortcut icon" href="./favicon.ico" > >> >> type="image/x-icon" /> > >> >> <title>phpMyAdmin</title> > >> >> <meta http-equiv="Content-Type" content="text/html; > >> >> charset=utf-8" /> > >> >> <link rel="stylesheet" type="text/css" > >> >> > >> href="./css/phpmyadmin.css.php?token=7c73a56802fc2e39fe41180d7 21&js_frame=right" > >> > >> >> > >> >> /> > >> >> <link rel="stylesheet" type="text/css" > >> >> href="./css/print.css?token=7c73a56802fc2ee8b4239fe721" > >> media="print" /> > >> >> <script type="text/javascript" language="javascript"> > >> >> // <![CDATA[ > >> >> // Updates the title of the frameset if possible (ns4 does not > >> allow > >> >> this) > >> >> if (typeof(parent.document) != 'undefined' && > >> >> typeof(parent.document) != 'unknown' > >> >> && typeof(parent.document.title) == 'string') { > >> >> parent.document.title = 'www.lazarusalliance.com / > >> localhost / > >> >> horsewiki / archive | phpMyAdmin 2.9.0.2'; > >> >> > >> >> > >> >> SQL query: > >> >> > >> >> -- phpMyAdmin SQL Dump -- version 2.9.0.2 -- > >> http://www.phpmyadmin.net > >> >> -- -- Host: localhost -- Generation Time: Oct 16, 2006 at 10:00 AM -- > >> >> Server version: 5.0.20 -- PHP Version: 5.1.6 -- -- Database: > >> >> `horsewiki` -- > >> >> ++++++++ > >> >> > >> >> I have not found a good source to understand what the problem > >> might be. > >> >> It does not help that I am such a greenhorn with databases either. I > >> >> would appreciate any assistance. > >> >> > >> >> Michael > >> >> > >> >> -- > >> >> MySQL General Mailing List > >> >> For list archives: http://lists.mysql.com/mysql > >> >> To unsubscribe: > >> >> http://lists.mysql.com/mysql?unsub=drbuettner@gmail.com > >> >> > >> >> > >> > >> > > > > |
|
02-27-2008, 09:35 PM
| |||
| |||
| Re: LOCK TABLES Hi From the analysis of other sources, The error may be due to: 1. MediaWiki was updated from an older version without updating the database. so to update the database, you can use either the maintenance script "maintenance/update.php" via the command line, or the web installer (rename LocalSettings.php, then go to the wiki). 2. --opt is enabled by default with mysqldump, and part of what it does it lock tables. So try the backup without lock tables, by adding --skip-lock-tables. Thanks ViSolve DB Team. ----- Original Message ----- From: "mdpeters" <mdpeters@lazarusalliance.com> To: <mysql@lists.mysql.com> Sent: Monday, October 16, 2006 9:14 PM Subject: LOCK TABLES >I am having a devil of a time moving a database from one server to > another. My database is one that is in production to support the > mediawiki wiki application. This is a Solaris Sparc 10 system using the > mysql-max-5.0.20a-solaris10-sparc version. My database name is horsewiki. > > I execute this: > # mysqldump --user root --password=password horsewiki > horsewiki.sql > and get this: > mysqldump: Got error: 1146: Table 'horsewiki.archive' doesn't exist when > using LOCK TABLES > > I have tried using phpMyAdmin-2.9.0.2. It seems to let me export the > database to an SQL file. When I attempt to import it on the other > system, I get this: > ++++++++ > Error > > There seems to be an error in your SQL query. The MySQL server error > output below, if there is any, may also help you in diagnosing the problem > > ERROR: Unknown Punctuation String @ 494 > STR: /> > SQL: -- phpMyAdmin SQL Dump > -- version 2.9.0.2 > -- http://www.phpmyadmin.net > -- > -- Host: localhost > -- Generation Time: Oct 16, 2006 at 10:00 AM > -- Server version: 5.0.20 > -- PHP Version: 5.1.6 > -- > -- Database: `horsewiki` > -- > <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" > "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> > <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en" > dir="ltr"> > <head> > <link rel="icon" href="./favicon.ico" type="image/x-icon" /> > <link rel="shortcut icon" href="./favicon.ico" type="image/x-icon" /> > <title>phpMyAdmin</title> > <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> > <link rel="stylesheet" type="text/css" > href="./css/phpmyadmin.css.php?token=7c73a56802fc2e39fe41180d7 21&js_frame=right" > /> > <link rel="stylesheet" type="text/css" > href="./css/print.css?token=7c73a56802fc2ee8b4239fe721" media="print" /> > <script type="text/javascript" language="javascript"> > // <![CDATA[ > // Updates the title of the frameset if possible (ns4 does not allow > this) > if (typeof(parent.document) != 'undefined' && > typeof(parent.document) != 'unknown' > && typeof(parent.document.title) == 'string') { > parent.document.title = 'www.lazarusalliance.com / localhost / > horsewiki / archive | phpMyAdmin 2.9.0.2'; > > > SQL query: > > -- phpMyAdmin SQL Dump -- version 2.9.0.2 -- http://www.phpmyadmin.net > -- -- Host: localhost -- Generation Time: Oct 16, 2006 at 10:00 AM -- > Server version: 5.0.20 -- PHP Version: 5.1.6 -- -- Database: `horsewiki` -- > ++++++++ > > I have not found a good source to understand what the problem might be. > It does not help that I am such a greenhorn with databases either. I > would appreciate any assistance. > > Michael > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=m...rt@visolve.com > |
|
02-27-2008, 09:35 PM
| |||
| |||
| Re: LOCK TABLES mysqldump --user root --password=password horsewiki > horsewiki.sql Dan Buettner wrote: > Hmmm, sounds like something's pretty abnormal here. Any idea what may > have been done here? > > I wonder if you could step around this with a call to mysqldump that > doesn't explicitly lock tables ... what is the commad you're running > again? > > Dan > > > On 10/16/06, mdpeters <mdpeters@lazarusalliance.com> wrote: > >> I tried mv archive.frm .archive.frm first. Then I ran mysqldump again. >> It moves past archive and onto another table. I did this 6 times, each >> time moving the next one it complained about until I stopped and put >> them all back. >> >> Dan Buettner wrote: >> >> > Try looking in the filesystem for the file(s) called "archive" in the >> > database directory, and move them somewhere else (or if you know you >> > don't need them, delete them). >> > >> > If it is/was a MyISAM table, or just an errant file, this should work. >> > If it is/was InnoDB, this will be trickier ... >> > >> > Dan >> > >> > >> > On 10/16/06, mdpeters <mdpeters@lazarusalliance.com> wrote: >> > >> >> As you can see, it is clearly showing up but I cannot do anything >> >> with it. >> >> >> >> mysql> show tables; >> >> +---------------------+ >> >> | Tables_in_horsewiki | >> >> +---------------------+ >> >> | archive | >> >> | categorylinks | >> >> | externallinks | >> >> | hitcounter | >> >> | horse_archive | >> >> | horse_categorylinks | >> >> | horse_externallinks | >> >> | horse_hitcounter | >> >> | horse_image | >> >> | horse_imagelinks | >> >> | horse_interwiki | >> >> | horse_ipblocks | >> >> | horse_job | >> >> | horse_logging | >> >> | horse_math | >> >> | horse_objectcache | >> >> | horse_oldimage | >> >> | horse_page | >> >> | horse_pagelinks | >> >> | horse_querycache | >> >> | horse_recentchanges | >> >> | horse_revision | >> >> | horse_searchindex | >> >> | horse_site_stats | >> >> | horse_templatelinks | >> >> | horse_text | >> >> | horse_trackbacks | >> >> | horse_transcache | >> >> | horse_user | >> >> | horse_user_groups | >> >> | horse_user_newtalk | >> >> | horse_validate | >> >> | horse_watchlist | >> >> | image | >> >> | imagelinks | >> >> | interwiki | >> >> | ipblocks | >> >> | job | >> >> | logging | >> >> | math | >> >> | objectcache | >> >> | oldimage | >> >> | page | >> >> | pagelinks | >> >> | querycache | >> >> | recentchanges | >> >> | revision | >> >> | searchindex | >> >> | site_stats | >> >> | templatelinks | >> >> | text | >> >> | trackbacks | >> >> | transcache | >> >> | user | >> >> | user_groups | >> >> | user_newtalk | >> >> | validate | >> >> | watchlist | >> >> +---------------------+ >> >> 58 rows in set (0.00 sec) >> >> >> >> mysql> SELECT * FROM archive LIMIT 1; >> >> ERROR 1146 (42S02): Table 'horsewiki.archive' doesn't exist >> >> >> >> mysql> drop table archive; >> >> ERROR 1051 (42S02): Unknown table 'archive' >> >> >> >> >> >> >> >> >> >> Dan Buettner wrote: >> >> >> >> > Michael, is the 'archive' table present in your database? e.g., if >> >> > you do a 'LIST TABLES', does it show up? What happens if you do a >> >> > "SELECT * FROM archive LIMIT 1" ? >> >> > >> >> > I'd hazard a guess that you may have a table definition file >> with no >> >> > actual table data files, if you're on MyISAM tables. >> >> > >> >> > If you don't need the archive table, can you DROP it successfully? >> >> > >> >> > Dan >> >> > >> >> > >> >> > On 10/16/06, mdpeters <mdpeters@lazarusalliance.com> wrote: >> >> > >> >> >> I am having a devil of a time moving a database from one server to >> >> >> another. My database is one that is in production to support the >> >> >> mediawiki wiki application. This is a Solaris Sparc 10 system >> >> using the >> >> >> mysql-max-5.0.20a-solaris10-sparc version. My database name is >> >> >> horsewiki. >> >> >> >> >> >> I execute this: >> >> >> # mysqldump --user root --password=password horsewiki > >> horsewiki.sql >> >> >> and get this: >> >> >> mysqldump: Got error: 1146: Table 'horsewiki.archive' doesn't >> >> exist when >> >> >> using LOCK TABLES >> >> >> >> >> >> I have tried using phpMyAdmin-2.9.0.2. It seems to let me >> export the >> >> >> database to an SQL file. When I attempt to import it on the other >> >> >> system, I get this: >> >> >> ++++++++ >> >> >> Error >> >> >> >> >> >> There seems to be an error in your SQL query. The MySQL server >> error >> >> >> output below, if there is any, may also help you in diagnosing the >> >> >> problem >> >> >> >> >> >> ERROR: Unknown Punctuation String @ 494 >> >> >> STR: /> >> >> >> SQL: -- phpMyAdmin SQL Dump >> >> >> -- version 2.9.0.2 >> >> >> -- http://www.phpmyadmin.net >> >> >> -- >> >> >> -- Host: localhost >> >> >> -- Generation Time: Oct 16, 2006 at 10:00 AM >> >> >> -- Server version: 5.0.20 >> >> >> -- PHP Version: 5.1.6 >> >> >> -- >> >> >> -- Database: `horsewiki` >> >> >> -- >> >> >> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" >> >> >> "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> >> >> >> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en" >> >> >> dir="ltr"> >> >> >> <head> >> >> >> <link rel="icon" href="./favicon.ico" type="image/x-icon" /> >> >> >> <link rel="shortcut icon" href="./favicon.ico" >> >> >> type="image/x-icon" /> >> >> >> <title>phpMyAdmin</title> >> >> >> <meta http-equiv="Content-Type" content="text/html; >> >> >> charset=utf-8" /> >> >> >> <link rel="stylesheet" type="text/css" >> >> >> >> >> >> href="./css/phpmyadmin.css.php?token=7c73a56802fc2e39fe41180d7 21&js_frame=right" >> >> >> >> >> >> >> >> >> /> >> >> >> <link rel="stylesheet" type="text/css" >> >> >> href="./css/print.css?token=7c73a56802fc2ee8b4239fe721" >> >> media="print" /> >> >> >> <script type="text/javascript" language="javascript"> >> >> >> // <![CDATA[ >> >> >> // Updates the title of the frameset if possible (ns4 does not >> >> allow >> >> >> this) >> >> >> if (typeof(parent.document) != 'undefined' && >> >> >> typeof(parent.document) != 'unknown' >> >> >> && typeof(parent.document.title) == 'string') { >> >> >> parent.document.title = 'www.lazarusalliance.com / >> >> localhost / >> >> >> horsewiki / archive | phpMyAdmin 2.9.0.2'; >> >> >> >> >> >> >> >> >> SQL query: >> >> >> >> >> >> -- phpMyAdmin SQL Dump -- version 2.9.0.2 -- >> >> http://www.phpmyadmin.net >> >> >> -- -- Host: localhost -- Generation Time: Oct 16, 2006 at 10:00 >> AM -- >> >> >> Server version: 5.0.20 -- PHP Version: 5.1.6 -- -- Database: >> >> >> `horsewiki` -- >> >> >> ++++++++ >> >> >> >> >> >> I have not found a good source to understand what the problem >> >> might be. >> >> >> It does not help that I am such a greenhorn with databases >> either. I >> >> >> would appreciate any assistance. >> >> >> >> >> >> Michael >> >> >> >> >> >> -- >> >> >> MySQL General Mailing List >> >> >> For list archives: http://lists.mysql.com/mysql >> >> >> To unsubscribe: >> >> >> http://lists.mysql.com/mysql?unsub=drbuettner@gmail.com >> >> >> >> >> >> >> >> >> >> >> > >> >> > |
|
02-27-2008, 09:35 PM
| |||
| |||
| Re: LOCK TABLES I tried this first to no avail. mysqldump --user root --password=password --skip-lock-tables horsewiki > horsewiki.sql mysqldump: mysqldump: Couldn't execute 'show create table `archive`': Table 'horsewiki.archive' doesn't exist (1146) I'll try the update next. Visolve DB Team wrote: > Hi > > From the analysis of other sources, > > The error may be due to: > > 1. MediaWiki was updated from an older version without updating the > database. so to update the database, you can use either the > maintenance script "maintenance/update.php" via the command line, or > the web installer (rename > LocalSettings.php, then go to the wiki). > 2. --opt is enabled by default with mysqldump, and part of what it > does it lock tables. So try the backup without lock tables, by adding > *--skip-lock-tables.* > > Thanks > ViSolve DB Team. > > ----- Original Message ----- > From: "mdpeters" <mdpeters@lazarusalliance.com > <mailto:mdpeters@lazarusalliance.com>> > To: <mysql@lists.mysql.com <mailto:mysql@lists.mysql.com>> > Sent: Monday, October 16, 2006 9:14 PM > Subject: LOCK TABLES > > >I am having a devil of a time moving a database from one server to > > another. My database is one that is in production to support the > > mediawiki wiki application. This is a Solaris Sparc 10 system using the > > mysql-max-5.0.20a-solaris10-sparc version. My database name is > horsewiki. > > > > I execute this: > > # mysqldump --user root --password=password horsewiki > horsewiki.sql > > and get this: > > mysqldump: Got error: 1146: Table 'horsewiki.archive' doesn't exist > when > > using LOCK TABLES > > > > I have tried using phpMyAdmin-2.9.0.2. It seems to let me export the > > database to an SQL file. When I attempt to import it on the other > > system, I get this: > > ++++++++ > > Error > > > > There seems to be an error in your SQL query. The MySQL server error > > output below, if there is any, may also help you in diagnosing the > problem > > > > ERROR: Unknown Punctuation String @ 494 > > STR: /> > > SQL: -- phpMyAdmin SQL Dump > > -- version 2.9.0.2 > > -- http://www.phpmyadmin.net > > -- > > -- Host: localhost > > -- Generation Time: Oct 16, 2006 at 10:00 AM > > -- Server version: 5.0.20 > > -- PHP Version: 5.1.6 > > -- > > -- Database: `horsewiki` > > -- > > <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" > > "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> > > <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en" > > dir="ltr"> > > <head> > > <link rel="icon" href="./favicon.ico" type="image/x-icon" /> > > <link rel="shortcut icon" href="./favicon.ico" type="image/x-icon" /> > > <title>phpMyAdmin</title> > > <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> > > <link rel="stylesheet" type="text/css" > > > href="./css/phpmyadmin.css.php?token=7c73a56802fc2e39fe41180d7 21&js_frame=right" > > > /> > > <link rel="stylesheet" type="text/css" > > href="./css/print.css?token=7c73a56802fc2ee8b4239fe721" media="print" /> > > <script type="text/javascript" language="javascript"> > > // <![CDATA[ > > // Updates the title of the frameset if possible (ns4 does not allow > > this) > > if (typeof(parent.document) != 'undefined' && > > typeof(parent.document) != 'unknown' > > && typeof(parent.document.title) == 'string') { > > parent.document.title = 'www.lazarusalliance.com / localhost / > > horsewiki / archive | phpMyAdmin 2.9.0.2'; > > > > > > SQL query: > > > > -- phpMyAdmin SQL Dump -- version 2.9.0.2 -- http://www.phpmyadmin.net > > -- -- Host: localhost -- Generation Time: Oct 16, 2006 at 10:00 AM -- > > Server version: 5.0.20 -- PHP Version: 5.1.6 -- -- Database: > `horsewiki` -- > > ++++++++ > > > > I have not found a good source to understand what the problem might be. > > It does not help that I am such a greenhorn with databases either. I > > would appreciate any assistance. > > > > Michael > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: > http://lists.mysql.com/mysql?unsub=m...rt@visolve.com > > |
|
02-27-2008, 09:35 PM
| ||||
| ||||
| RE: LOCK TABLES I wonder if this is a permissions problem. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 > -----Original Message----- > From: mdpeters [mailto:mdpeters@lazarusalliance.com] > Sent: Monday, October 16, 2006 9:19 PM > To: Dan Buettner > Cc: mysql@lists.mysql.com > Subject: Re: LOCK TABLES > > I tried mv archive.frm .archive.frm first. Then I ran > mysqldump again. > It moves past archive and onto another table. I did this 6 > times, each > time moving the next one it complained about until I stopped and put > them all back. > > Dan Buettner wrote: > > > Try looking in the filesystem for the file(s) called > "archive" in the > > database directory, and move them somewhere else (or if you know you > > don't need them, delete them). > > > > If it is/was a MyISAM table, or just an errant file, this > should work. > > If it is/was InnoDB, this will be trickier ... > > > > Dan > > > > > > On 10/16/06, mdpeters <mdpeters@lazarusalliance.com> wrote: > > > >> As you can see, it is clearly showing up but I cannot do anything > >> with it. > >> > >> mysql> show tables; > >> +---------------------+ > >> | Tables_in_horsewiki | > >> +---------------------+ > >> | archive | > >> | categorylinks | > >> | externallinks | > >> | hitcounter | > >> | horse_archive | > >> | horse_categorylinks | > >> | horse_externallinks | > >> | horse_hitcounter | > >> | horse_image | > >> | horse_imagelinks | > >> | horse_interwiki | > >> | horse_ipblocks | > >> | horse_job | > >> | horse_logging | > >> | horse_math | > >> | horse_objectcache | > >> | horse_oldimage | > >> | horse_page | > >> | horse_pagelinks | > >> | horse_querycache | > >> | horse_recentchanges | > >> | horse_revision | > >> | horse_searchindex | > >> | horse_site_stats | > >> | horse_templatelinks | > >> | horse_text | > >> | horse_trackbacks | > >> | horse_transcache | > >> | horse_user | > >> | horse_user_groups | > >> | horse_user_newtalk | > >> | horse_validate | > >> | horse_watchlist | > >> | image | > >> | imagelinks | > >> | interwiki | > >> | ipblocks | > >> | job | > >> | logging | > >> | math | > >> | objectcache | > >> | oldimage | > >> | page | > >> | pagelinks | > >> | querycache | > >> | recentchanges | > >> | revision | > >> | searchindex | > >> | site_stats | > >> | templatelinks | > >> | text | > >> | trackbacks | > >> | transcache | > >> | user | > >> | user_groups | > >> | user_newtalk | > >> | validate | > >> | watchlist | > >> +---------------------+ > >> 58 rows in set (0.00 sec) > >> > >> mysql> SELECT * FROM archive LIMIT 1; > >> ERROR 1146 (42S02): Table 'horsewiki.archive' doesn't exist > >> > >> mysql> drop table archive; > >> ERROR 1051 (42S02): Unknown table 'archive' > >> > >> > >> > >> > >> Dan Buettner wrote: > >> > >> > Michael, is the 'archive' table present in your > database? e.g., if > >> > you do a 'LIST TABLES', does it show up? What happens > if you do a > >> > "SELECT * FROM archive LIMIT 1" ? > >> > > >> > I'd hazard a guess that you may have a table definition > file with no > >> > actual table data files, if you're on MyISAM tables. > >> > > >> > If you don't need the archive table, can you DROP it > successfully? > >> > > >> > Dan > >> > > >> > > >> > On 10/16/06, mdpeters <mdpeters@lazarusalliance.com> wrote: > >> > > >> >> I am having a devil of a time moving a database from > one server to > >> >> another. My database is one that is in production to support the > >> >> mediawiki wiki application. This is a Solaris Sparc 10 system > >> using the > >> >> mysql-max-5.0.20a-solaris10-sparc version. My database name is > >> >> horsewiki. > >> >> > >> >> I execute this: > >> >> # mysqldump --user root --password=password horsewiki > > horsewiki.sql > >> >> and get this: > >> >> mysqldump: Got error: 1146: Table 'horsewiki.archive' doesn't > >> exist when > >> >> using LOCK TABLES > >> >> > >> >> I have tried using phpMyAdmin-2.9.0.2. It seems to let > me export the > >> >> database to an SQL file. When I attempt to import it on > the other > >> >> system, I get this: > >> >> ++++++++ > >> >> Error > >> >> > >> >> There seems to be an error in your SQL query. The MySQL > server error > >> >> output below, if there is any, may also help you in > diagnosing the > >> >> problem > >> >> > >> >> ERROR: Unknown Punctuation String @ 494 > >> >> STR: /> > >> >> SQL: -- phpMyAdmin SQL Dump > >> >> -- version 2.9.0.2 > >> >> -- http://www.phpmyadmin.net > >> >> -- > >> >> -- Host: localhost > >> >> -- Generation Time: Oct 16, 2006 at 10:00 AM > >> >> -- Server version: 5.0.20 > >> >> -- PHP Version: 5.1.6 > >> >> -- > >> >> -- Database: `horsewiki` > >> >> -- > >> >> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" > >> >> "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> > >> >> <html xmlns="http://www.w3.org/1999/xhtml" > xml:lang="en" lang="en" > >> >> dir="ltr"> > >> >> <head> > >> >> <link rel="icon" href="./favicon.ico" type="image/x-icon" /> > >> >> <link rel="shortcut icon" href="./favicon.ico" > >> >> type="image/x-icon" /> > >> >> <title>phpMyAdmin</title> > >> >> <meta http-equiv="Content-Type" content="text/html; > >> >> charset=utf-8" /> > >> >> <link rel="stylesheet" type="text/css" > >> >> > >> > href="./css/phpmyadmin.css.php?token=7c73a56802fc2e39fe41180d7 > 21&js_frame=right" > >> > >> >> > >> >> /> > >> >> <link rel="stylesheet" type=& |