473,320 Members | 1,990 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Replication and mysqdump issue with database name

Jon
I have a database called abc-100 which seems to cause problems with
replication and importing sql files created with mysqldump.

First, if on the master we create a temporary table (because we don't
have subselects yet) it causes the slave to die with the following.

Relay log says:

DROP /*!40005 TEMPORARY */ TABLE abc-100.temp_summary

And the error log says:

ERROR: 1064 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 '-100.temp_summary

Second, on doing a mysql < dump.sql for a database restore, I have to
manually edit the dump file first and use `` around the abc-100.

So, apparently the - or the -100 is an invalid database name? If so,
why would mysql allow me to create it in the first place? Is there
any way to make this work without changing the database name?
Changing the name is not a trivial matter because I am dealing with
many databases with the same issue, 100, 101, 102 etc. I am more
concerned with replication than the dump.sql as I can always edit the
database names to be contained in ``.

Thanks for any help you can offer.

Jon
Jul 19 '05 #1
4 2704
Jon
Interesting, I seem to have found this the same time as the bug was
entered by someone else:

Bug #1345 SQL Syntax Error in binarylog with DROP TABLES

http://bugs.mysql.com/bug.php?id=1345&error=lp

So, the issue is that the slave has a problem with the abc-xyz db name
but the master does not.
Jul 19 '05 #2
Jon
> Have you tried putting your tablename between backticks?

This is not the issue because it works fine on the master and only
fails on the slave. I have since discovered that it is a verified bug
(#1345) with mysq.
Jul 19 '05 #3
Jon
Interesting, I seem to have found this the same time as the bug was
entered by someone else:

Bug #1345 SQL Syntax Error in binarylog with DROP TABLES

http://bugs.mysql.com/bug.php?id=1345&error=lp

So, the issue is that the slave has a problem with the abc-xyz db name
but the master does not.
Jul 19 '05 #4
Jon
> Have you tried putting your tablename between backticks?

This is not the issue because it works fine on the master and only
fails on the slave. I have since discovered that it is a verified bug
(#1345) with mysq.
Jul 19 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Jon | last post by:
I have a database called abc-100 which seems to cause problems with replication and importing sql files created with mysqldump. First, if on the master we create a temporary table (because we...
2
by: Ian Wyld | last post by:
Hello All We intend to replicate a database in order to have it as a near immediate standby in case of the failure of the main server. Is this the best solution for disaster recovery? We...
5
by: johnm | last post by:
Here is my situation. We run a very mission critical application that uses DB2 7.2 for the data repository. The database is hosed at a data center in Los Angeles, Ca. Our main office...
4
by: Andi Plotsky | last post by:
I need to synchronize 3 databases (1 Master and 2 replicas). I thought I'd give the Replica feature in Access2000 a whirl. I'm not sure I'm THAT impressed.....but maybe I'm just doing something...
9
by: David W. Fenton | last post by:
See: Updated version of the Microsoft Jet 4.0 Service Pack 8 replication files is available in the Download Center http://support.microsoft.com/?scid=kb;en-us;321076 This includes the Jet 4...
3
by: Juan Antonio Villa | last post by:
Hello, I'm having a problem replicating a simple database using the binary log replication, here is the problem: When the master sends an update to the slave, an example update reads as follows:...
6
by: Alex | last post by:
Hello, We are currently running our Access 2003 database over Citrix. We have been using a single front-end, but reading over topics in this group has made it clear that I should create...
8
by: sat | last post by:
Hi All! I have a small doubt in replication.Previously i was working on replication with the databases under the same instance.So it worked fine. Now i'm facing a new problem which is like, now...
2
by: Query Builder | last post by:
I have a wired situation..! I set up transactional replication on one of my development server (SQL 2000 Dev Edition with sp4). It is running fine without any issues and all of a sudden, i...
2
by: Query Builder | last post by:
Hi, I have transactional replication set up on on of our MS SQL 2000 (SP4) Std Edition database server Because of an unfortunate scenario, I had to restore one of the publication databases. I...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.