Jesse wrote:
This may be a really stupid question, but I hate looking stupid if I
can avoid it. :-)
I have been using Microsoft SQL Server for a while, and I'm now trying
to switch all our applications over to use MySQL. Microsoft SQL
Server is pronounced Sequel Server. Is MySQL pronounced
off my replicated queries.
- the error log gives a stack dump, and says this could be because you
hit a bug. I'm looking for a little more information than that...
- ian
--
+---+
| Ian Sales
as system user. There is no
system user in the privilege tables, so I can't give the account the
privileges necessary to run triggers. As a result, the triggers always
fail and break replication.
- ian
--
+---+
| Ian Sales
--
+---+
| Ian Sales Database Administrator |
| |
| All your database are belong to us |
| ebuyer http
, 2004
£29.26
- the second one is German language.
- ian
--
+---+
| Ian Sales Database Administrator
, the problem I have is that the triggers
themselves are not being replicated; they exist only on the 5.0.17 slave.
- ian
--
+---+
| Ian Sales Database Administrator
that was added with 5.0.17 that seems to be causing the problem.
- ian
--
+---+
| Ian Sales Database Administrator
and then assigning INSERT, UPDATE, DELETE, SELECT and
SUPER privileges to that user. To no avail.
Anyone have any ideas how to resolve this?
Thanks
- ian
--
+---+
| Ian Sales Database Administrator
... Our core database
platform contains some 2,600 tables in 50 databases. And that's only one
of 8 platforms...
- ian
--
+---+
| Ian Sales Database Administrator
= invoices.customer_id
GROUP BY customers.id
ORDER BY customers.creation desc
Thanks!
- you need a LEFT JOIN. See http://dev.mysql.com/doc/refman/5.0/en/join.html
- ian
--
+---+
| Ian Sales Database
.,
CREATE TRIGGER InsPopCoord AFTER INSERT ON locations FOR EACH ROW
UPDATE zipcodes
SET zipcodes.lat=NEW.lat, zipcodes.lon=NEW.lon
WHERE zipcodes.zip=NEW.zip;
- ian
--
+---+
| Ian Sales Database
3 times and i got the follwing
error
Invalid Query Lock wait timeout exceeded; try restarting transaction
- try using SHOW INNODB STATUS. That will give you more info on table locks.
- ian
--
+---+
| Ian Sales
--
+---+
| Ian Sales Database Administrator |
| |
| All your database are belong to us |
| ebuyer http://www.ebuyer.com
...
- don't split data into separate tables by location. Seperate it by the
type of information.
- ian
--
+---+
| Ian Sales Database Administrator
--
+---+
| Ian Sales Database Administrator |
| |
| All your database are belong to us |
| ebuyer http://www.ebuyer.com
--
+---+
| Ian Sales Database Administrator |
| |
| All your database are belong to us |
| ebuyer
RDBMS are *really*
relational, check out http://www.dbdebunk.com/index.html :-)
- ian
--
+---+
| Ian Sales Database Administrator
to
enforce referential integrity programmatically. MySQL won't do it for you.
- ian
--
+---+
| Ian Sales Database Administrator
://dev.mysql.com/doc/mysql/en/string-functions.html
- ian
--
+---+
| Ian Sales Database Administrator |
| |
| All your
--
+---+
| Ian Sales Database Administrator |
| |
| All your database are belong to us |
| ebuyer http
.
- I'd recommend not using float for money. You get rounding errors.
- ian
--
+---+
| Ian Sales Database Administrator
)
--
+---+
| Ian Sales Database Administrator |
| |
| All your database are belong to us |
| ebuyer http://www.ebuyer.com
loging.
- MySQL will only allow you to join 32 tables in a single SQL statement.
- ian
--
+---+
| Ian Sales Database Administrator
using date_format and now(). See
http://dev.mysql.com/doc/mysql/en/date-and-time-functions.html
- ian
--
+---+
| Ian Sales Database Administrator
--
+---+
| Ian Sales Database Administrator |
| |
| If your DBA is busy all the time... |
| ...he's not doing his job properly
table, and simply write the query as a join between the
animals table and the locations table? Hard-coding the meaning of ids
into the code itself is never a good idea.
- ian
--
+---+
| Ian Sales
, Smithsonian...
- ian
--
+---+
| Ian Sales Database Administrator |
| |
| If your DBA is busy all the time
. Any help is greatly appreciated!
Define DoS?
- Denial of Service...
- ian
--
+---+
| Ian Sales Database Administrator
.
- ian
--
+---+
| Ian Sales Database Administrator |
| |
| If your DBA is busy all the time
work...
performer_group_id, performer_person_id, lyricist_person_id, etc. There
will be one row per recording of a song, although some columns on that
row may be empty.
- ian
--
+---+
| Ian Sales
) to see
what caused mysqld to die.
- ian
--
+---+
| Ian Sales Database Administrator |
| |
| If your DBA
--
+---+
| Ian Sales Database Administrator |
| |
| If your DBA is busy all the time... |
| ...he's not doing his job properly
= 0 to turn off referentiality checking.
- ian
--
+---+
| Ian Sales Database Administrator |
| |
| If your
.
- ian
--
+---+
| Ian Sales Database Administrator |
| |
| If your DBA is busy all the time
to be absolutely certain I'm counting every
instance of each value of status. I've not investigated to see whether I
*really* need to do this, but it feels safer...
- ian
--
+---+
| Ian Sales Database
) LIKE 'cancelled%',1,0)) as cancelled
FROM
account
GROUP BY date;
- ian
--
+---+
| Ian Sales Database Administrator |
| |
| eBuyer
.
- delete the master.info file in the data directory, and then use CHANGE
MASTER ... to set the required values before starting replication on the
slave.
- ian
--
+---+
| Ian Sales Database
and see.
- ian
--
+---+
| Ian Sales Database Administrator |
| |
| eBuyer http://www.ebuyer.com
of anything special
going on at these times.
- one possibility could be DNS refreshes taking place... Do you have the
web server's name and IP in the hosts file on the database server?
- ian
--
+---+
| Ian Sales
to be distributed to all the columns of the table. What could i be
doing wrong here.
- add FIELDS TERMINATED BY ',' ENCLOSED BY '' to your LOAD DATA INFILE
- ian
--
+---+
| Ian Sales Database
solve this .
- if you're copying the csv file between a Windows and a *NIX box, you
might have issues with carriage-return characters. Try running dos2unix
against the file to convert it.
- ian
--
+---+
| Ian Sales
there
either...
Any suggestions?
- you've got a Cartesian results set because you haven't joined the
tables. Try joining on name, or writing two queries and then using a UNION.
- ian
--
+---+
| Ian Sales
the command line run a SQL script containing
SELECT CONCAT_WS(',', ...column names...) etc., and pipe the output into
a .csv file. Excel will happily import the data. There'll be no column
headings, though.
- ian
--
+---+
| Ian Sales
[EMAIL PROTECTED] wrote:
Need to know the similar one in MySQL. Do we have views or any other
system tables in MySQL 4.0.21 which OUTPUTS the constraints and indices
in a particular table?
- show indexes from DATABASE_NAME.TABLE_NAME
- or, show create table DATABASE_NAME.TABLE_NAME;
- ian
--
in set (0.00 sec)
Common sense expects the number of rows returned to be four. So where's
the Cartesian coming from?
- ian
--
| Ian Sales Broadband Solutions for |
| Database AdministratorHome Business |
| PlusNet plc
for the help.
- ian
--
| Ian Sales Broadband Solutions for |
| Database AdministratorHome Business |
| PlusNet plc http://www.plus.net |
+ --- PlusNet - The Smarter Way to Internet
46 matches
Mail list logo