Hi All!
I'm using the latest mysql 4.0.x and I've successfully
set-up database replication on it over 2 machines.
I have noticed though that mysql doesn't seem to
replicate CREATE TABLE operations on the master to the
slave. Is this a limitation? Or I just missed
something. If so, can someone ple
Is there a way to tell mysqldump to dump all tables in
the specified database except certain specified
tables?
Like maybe: "mysqldump dbname !exclude_this_table >
data.sql"?
I have about 200 tables in my database and I only need
to back-up about 98% of them. The other 2% are HUGE
temporary searc
Is the 2GB filesize limit in linux still there?
Specially in Gentoo and Debian linux?
If so, how can this be addressed when your mysql's
.MYD files reach 2GB?
Is there any way MySQL can split really big .MYD
files?
Regards,
Shannon
__
Do you
good day all!
i'm getting really confused with how to properly allow
users to access mysql from other machines.
that is, i tried this as mysql root user:
GRANT SELECT, INSERT, UPDATE, DELETE ON my_sql_db.* TO
[EMAIL PROTECTED] IDENTIFIED BY 'password';
after this, i can access mysql as 'dbus
hello list!
i'll be moving from a RedHat server to a Debian server very soon. despite the
different linux distributions, is it ok to transfer my entire mysql database by just
copying everything in /var/lib/mysql of the RedHat system to the Debian system? has
anyone tried this before?
the r
