Re: MYSQLDUMP not responding to the PORT option
It's my understanding that when you specify localhost, the mysql client program will use the UNIX socket (ie, mysql.sock), and not look at port information. cheers, jenni Michael Williams wrote: Hi all, I'm trying to use "mysqldump" over SSH. I'm pretty familiar with port forwarding in and of itself, so I doubt that's the issue. No matter what port I forward (or to where for that matter), "mysqldump" still connects to the local MySQL server and dumps local data. It's as if it completely disregards my PORT option. Any ideas? My commands are as follows: %ssh -L 8080:localhost:3306 remote_server_ip %mysqldump -u user_name --port=8080 --compact --quick --all- databases > dumpfile Depending on the "user_name" it either fails or dumps my local data. It doesn't even use --port Regards, Michael -- Jennifer Snyder Database Administrator Tribe Networks, Inc. www.tribe.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
warming the cache after restart
Good Afternoon. I'm interested if any DBAs on the list have a set of scripts they run after a server restart to pull commonly accessed data into the the query and key caches. I'm currently working on a script that will run various queries from our application against the database servers after restart, in hopes that it will shorten the amount of time it takes for the caches to fill and stabalize. I'm excited to see that MySQL 4.1.1 will have direct commands to do some of this, (see http://dev.mysql.com/doc/mysql/en/LOAD_INDEX.html), but that doesn't help me now... Is there anyone else on this list who has looked at this issue or can point me in the direction of more information about it? thanks a bunch, jenni -- Jennifer Snyder Database Administrator Tribe Networks, Inc. www.tribe.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]