mysql total replication question
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 please give me a clue or point me to the right place documentations? Also, is it possible to setup replication so that everything in the master is replicated to the slave, included CREATE DATABASE operations? Many Thanks! Shannon __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysqldump exclude table option
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 search index tables which can be rebuilt anyway in case the dump has to be retored. Ideas anyone? Thanks! Shannon ___ Do you Yahoo!? Declare Yourself - Register online to vote today! http://vote.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
on big mysql .MYD files and linux's 2GB file size limit
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 Yahoo!? Yahoo! Mail - 50x more storage than other providers! http://promotions.yahoo.com/new_mail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
problem with making mysql accessible from other machines
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 'dbuser' from the localhost. the mysql servers ip add by the way is 192.168.1.1, and since i also want that user to be able to access from 192.168.1.2, i also did this command: GRANT SELECT, INSERT, UPDATE, DELETE ON my_sql_db.* TO [EMAIL PROTECTED] IDENTIFIED BY 'password'; that should have been it but whenever i try to access mysql from 192.168.1.2, i keep getting an "Can't connect to MySQL server" error. did i do anything wrong? that's what the documentation said and i just followed it. also, what if i also want to allow mysql access from 192.168.1.3? but not with the rest of the addresses on 192.168.0.0? how do i do that? and there's yet another thing which confused me. if i do 'mysql -u root -p' from the mysql server itself, i can connect to it, but if i do 'mysql -u root -p -h 192.168.0.1', or just pointing to itself, i get the same 'cant connect to mysql' error. anyone can shed any light on why is this so? thanks! shannon __ Do you Yahoo!? Yahoo! Mail - 50x more storage than other providers! http://promotions.yahoo.com/new_mail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
transferring MySQL db from RedHat to Debian
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 reason why i don't want to do the database transfer using data generated by mysqldump is because i want all the auto-generated record_ids to stay the same in the new system. any help will be greatly appreciated. thanks! shannon - Do you Yahoo!? Yahoo! Mail Address AutoComplete - You start. We finish.