Hi Guys

We need some assistance with a master slave setup we are
experiencing some issues with.

We have one master with 2 slaves replicating from it.

Both the slaves stopped working this morning in the early hours
at exactly the same bin_log file and position.

We have since restarted the slave servers and when you run a
"show slave status" the seconds behind master stays "0".

Upon closer investigation, the Relay_Master_Log_File and
Exec_Master_Log_Pos does not change, although all other values are changing.

No errors are being lo

Hi All

I am busy investigating some options relating to the backup for
MySQL databases when they get quite large.

When using the MySQL enterprise, there is the option to use the
MySQL enterprise backup as it is part of the Enterprise license.

However, when using the GA (freely available) versions, the
options for backups on large databases seems to be a bit limited.

Using mysqldump and restores on an 80-100GB database seems a
bit unpractical as the restore times seems to get quite long as well as
the backup times.

Does anybody have some ideas on ba

Hi All

I am hoping someone can point me in the right direction.

We have a mysql 5.0 database which is giving us hassles when trying
to create a temporary table.

The creation works perfectly on the slave machine as well as all
our other db's, however on the one specific main server we are getting
the message "ERROR 1005 (HY000): Can't create table
'/tmp/#sql4a27_68eed1_0.frm' (errno: -1)"

We have been trying to figure this out for more than a week now
with no luck.

When looking in the mysql error.log file, the innodb states that
there is either another mys

Good day all

I have someone who has asked me the following, however due to not
having that many years of experience in these type of volumes, I am
posting this as I know that someone will probably be able to answer it
better than me.

(This will also give me a learning opportunity to see what to do)

_*Client Question: *_

Well let me describe the issue.

1.I require to load records into a MySQL database table - no problem so
far ;-)

2.The table represents "stock" that will be being searched and
transacted (i.e.

Hi Guys

Can someone please confirm whether replication / standby
functionality is available on the GA release of MySQL or this an
Enterprise specific functionality?

Regards
Machiel

Good day all

I am hoping everyone is well.....

Can someone perhaps assist me with some resources on the following
topic

one of our clients are running a MySQL 5 master/slave replication
setup.

There is a DR test schedule during next month, however they want the
slave server to become the master and the master server to become the
slave server.

I am busy looking into how to setup a master / slave replication,
however I am trying to find out how to do the relevant changes as
mentioned above.

The next test they then want to do is to test the switch over to the

Good day all

I am looking for someone that can maybe help me with some info
regarding the upgrading of MySQL.

We have a MySQL database currently running with a master/slave
replication setup.

The current version of the database is as follows:

mysql> select version();
+------------------------------+
| version() |
+------------------------------+
| 5.0.72sp1-enterprise-gpl-log |
+------------------------------+
1 row in set (0.00 sec)

This

Good day guys

I previously requested information regarding the exporting
of data which needs to be imported into oracle.

We are however still struggling with the data though and
maybe someone can give me some ideas...

It seems that one of the tables we need to export and import
contains rows which is used for dropdown menus.

This has the following effect:

. Each item in the "text" field is added in the field by entering
the country name then pressing enter and then entering the next, etc....

.

Hi guys,

Can you please assist me in rewriting this query in order to run this
against a mysql database?

It seems that the decode function does not exist in mysql.

select

decode(nvl(receive_email, 'No'), 'Yes', 'Yes', 'No') email_corr,

count(*) tot

from profiles

where email is not null

group by (decode(nvl(receive_email, 'No'), 'Yes', 'Yes', 'No'))

Good day all...

I have some questions regarding data handling when doing
exports in mysql.

This is a follow up on my mails yesterday about the exports
within a cron.

What we found now was places where the users for instance
manually entered a "\" in a field and the export then carries the next field
over to a new line thus causing problems with the imports as it is seen as a
new line and the amounts of fields do not correspond to the table.

The second thing we found was that one of the fields is a
varchar(255) f

Hi all

I have a question regarding exporting of tables to a file
from mysql.

We need to export tables from mysql to a delimeted file
which will then be imported into another database (oracle).

We can do this manually from within mysql using the
following command:

select * from <table> into outfile
'/path/to/output/file' fields terminated by '|';

This needs to be configured though to be run in a cron once
every week at a specific time.

How can we do this when r

Good day all

I hope that someone can help me out with some resources.

Due to lack of interest my MySQL training was cancelled in
December.

However I need to get certified (MySQL DBA) ASAP and need to
do this on book knowledge and a bit of experience alone.

Due to the cost for the exams I cannot afford to fail any
one of the two exams.

I am trying to get hold of sample exams, etc...

Good day guys (and girls if any)

I am constantly in a position where variables on a
production mysql database needs to be changed.

The database runs a 24/7 system and thus to reboot is not
preffered and should be the absolute last resort.

How can I set variables to be effective immediately? ( I
am still a junior in mysql dba and still learning)

If I set these will it still be effective should the
database be restarted somewhere in the future?

Thanks in advance for your help.

Regards

Good day all

I hope that someone can help me out.

We have a MySQL database where the INNODB_BUFFER_POOL_SIZE
keeps on filling up.

If the database is restarted, the buffer pool is cleared,
however from there it just starts filling up again until 100% full.

We tried increasing the value however the same just happens
over again, it starts getting used more and more until it is 100% full.

Does anybody know how we can get this resolved to first of
all determine why this is happening now and second of

Hi all

I hope someone can help me out here as I am still new with MySQL.

I am trying to determine when last a MySQL database was shut down and
when last the tables were analyzed.

Can someone please assist in this and let me know if this is
possible.

Your assistance is appreciated.

Regards

Machiel

Hi All

We are experiencing some problems when trying to connect to a mysql database
using ODBC.

The settings have been configured and it seems to be getting to the DB but
we getting the following error:

[S1T00][unixODBC][MySQL][ODBC 3.51 Driver]Access denied for user
'root'@'hostname'
(using password: YES)
[ISQL]ERROR: Could not SQLConnect

can some perhaps assist please?

Regards