An Error While Executing A Query.

[Khushboo]

Hi,

We will need some more information , to solve your issue.

So can you please tell us :

1) With what program was that dump (SQL file) generated? 'mysqldump' ?

2) From what MySQL version?

3) To what version do you try to import ?

4) SQLyog program version?

Regards,

Khushboo

[bunkbunk]

Khushboo wrote on Jun 25 2009, 05:38 AM:

Hi,

We will need some more information , to solve your issue.

So can you please tell us :

1) With what program was that dump (SQL file) generated? 'mysqldump' ?

2) From what MySQL version?

3) To what version do you try to import ?

4) SQLyog program version?

Regards,

Khushboo

plz stay online i will git the info soon

again thanks!

[bunkbunk]

I don't know how the SQL file was made, though i did a import of it be for and it was working “mind you this was just a few hours ago”

i think MYSQL is 4.1 or some where in the 4's the 5's wont work for me on this computer “

don't understand the 3'rd one

SQLyog is 8 (point) some thing

again it was working, all i did was delete the data base's and make them again and boom they don't work any more

[Mahesh]

Please zip and attach .sql dump file here, we will analyze and let you know the status.

[bunkbunk]

Mahesh wrote on Jun 25 2009, 06:05 AM:

Please zip and attach .sql dump file here, we will analyze and let you know the status.

here you go

Thanks!

[Mahesh]

Attached .sql dump “imports successfully” at our end we have checked against 5.x as well as 4.x servers.

Please provide a sample testcase to reproduce those errors mentioned in above post, then only we can do some progress.

Thanks

[bunkbunk]

Mahesh wrote on Jun 25 2009, 06:52 AM:

Attached .sql dump “imports successfully” at our end we have checked against 5.x as well as 4.x servers.

Please provide a sample testcase to reproduce those errors mentioned in above post, then only we can do some progress.

Thanks

i know it work's it DID work for me now it's blah, i don't know what's going on i just delete all the data base's on SQLyog and than try to make them again i mean is it that i don't have the mysql data base there any more or what?

thanks again for the fast help

i will stay online for a week if that's what it take's to get going again

[bunkbunk]

bunkbunk wrote on Jun 25 2009, 06:58 AM:

i know it work's it DID work for me now it's blah, i don't know what's going on i just delete all the data base's on SQLyog and than try to make them again i mean is it that i don't have the mysql data base there any more or what?

thanks again for the fast help

i will stay online for a week if that's what it take's to get going again

i got it working, i had to re-move MYSQL all together seem's when i went to restart mysql server it would not, i was then thinking that my computer did some thing with out me lol, well i did a re install, made the server again and, did the dump for the sql file's and they all work,

Thank you so much guy's for your time, and i'am so happy that you took the time to take a look at the sql file's, and for being there so fast, well THANKS!

[kage]

bunkbunk wrote on Jun 25 2009, 03:34 AM:

Code:

Query:
/*!40103 SET TIME_ZONE='+00:00' */

Error occured at:2009-06-25 00:20:45
Line no.:12
Error Code: 1146 – Table 'mysql.time_zone_name' doesn't exist

Query:
/*!40103 SET TIME_ZONE='+00:00' */

Error occured at:2009-06-25 00:21:29
Line no.:12
Error Code: 1146 – Table 'mysql.time_zone_name' doesn't exist

Query:
/*!40103 SET TIME_ZONE='+00:00' */

Error occured at:2009-06-25 00:22:17
Line no.:12
Error Code: 1146 – Table 'mysql.time_zone_name' doesn't exist

Query:
/*!40103 SET TIME_ZONE='+00:00' */

Error occured at:2009-06-25 00:23:20
Line no.:12
Error Code: 1146 – Table 'mysql.time_zone_name' doesn't exist

Query:
/*!40103 SET TIME_ZONE='+00:00' */

Error occured at:2009-06-25 00:27:33
Line no.:12
Error Code: 1146 – Table 'mysql.time_zone_name' doesn't exist

Query:
/*!40103 SET TIME_ZONE='+00:00' */

Error occured at:2009-06-25 00:29:03
Line no.:12
Error Code: 1146 – Table 'mysql.time_zone_name' doesn't exist

Query:
/*!40103 SET TIME_ZONE='+00:00' */

Error occured at:2009-06-25 00:29:45
Line no.:12
Error Code: 1146 – Table 'mysql.time_zone_name' doesn't exist

Query:
/*!40103 SET TIME_ZONE='+00:00' */

Error occured at:2009-06-25 00:30:01
Line no.:12
Error Code: 1146 – Table 'mysql.time_zone_name' doesn't exist

Query:
/*!40103 SET TIME_ZONE='+00:00' */

Error occured at:2009-06-25 00:33:19
Line no.:12
Error Code: 1146 – Table 'mysql.time_zone_name' doesn't exist

Query:
/*!40103 SET TIME_ZONE='+00:00' */

Error occured at:2009-06-25 00:42:15
Line no.:12
Error Code: 1146 – Table 'mysql.time_zone_name' doesn't exist

Query:
/*!40103 SET TIME_ZONE='+00:00' */

Error occured at:2009-06-25 00:42:21
Line no.:12
Error Code: 1146 – Table 'mysql.time_zone_name' doesn't exist

Query:
/*!40103 SET TIME_ZONE='+00:00' */

Error occured at:2009-06-25 00:42:24
Line no.:12
Error Code: 1146 – Table 'mysql.time_zone_name' doesn't exist

Query:
GRANT USAGE ON * . * TO 'mangos'@'localhost' IDENTIFIED BY 'mangos' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0

Error occured at:2009-06-25 00:43:54
Line no.:1
Error Code: 1146 – Table 'mysql.user' doesn't exist

Query:
/*!40103 SET TIME_ZONE='+00:00' */

Error occured at:2009-06-25 00:45:40
Line no.:12
Error Code: 1146 – Table 'mysql.time_zone_name' doesn't exist

Query:
/*!40103 SET TIME_ZONE='+00:00' */

Error occured at:2009-06-25 00:49:26
Line no.:12
Error Code: 1146 – Table 'mysql.time_zone_name' doesn't exist

i know this is resolved and somewhat necro'd, i thought I would comment on this. specifically the mysql.tables doesn't exist error.

It would seem this person deleted, or had conection problems, to his mysql database?

[Mahesh]

When you update to a new version of MySQL, you should update your system tables as well to make sure that their structure is up to date.

For more information, please visit – http://dev.mysql.com/doc/refman/5.1/en/mysql-upgrade.html

[Author]

Posts