Re: mysqlbug
I might be interested in hiring someone to do some PhP, and MySQL programming on SuSQ 7.3. anyone live near Raleigh North Carolina? I am not sure I can learn what I need in the time frame I need to do it in. Mark - Original Message - From: Gregory Junker [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, March 13, 2002 7:13 PM Subject: RE: mysqlbug error 2 says the file cannot be found...did you run the mysql_install_db script? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 13, 2002 7:05 PM To: [EMAIL PROTECTED] Subject: mysqlbug Good afternoon Please, i'll need some help. I've installed mysql-3.22.32 in my machine, and when i run (from /usr/local/mysql) ./bin/safe_mysqld this is the bug that present (from my *.err file) /* / mysqld started on Mon Mar 4 15:44:29 PST 2002 /usr/local/mysql/libexec/mysqld: ready for connections mysqld started on Mon Mar 4 15:52:32 PST 2002 /usr/local/mysql/libexec/mysqld: Can't change dir to '/usr/local/mysql/data/' (Errcode: 2) 020304 15:52:33 Aborting /* **/ What is wrong??? Thank's Sincerely Ricardo Castro - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Mysql installation. Help!
What I did was beat my brains out on the same exact problem. In the end I have no clue what I did to get it actually working. I had re-installed the mysql from the .tar.gz, I installed all the RPM's several times. Everytime, I fully rebooted the system, and finally I have to run safe_mysqld --user=root I think finaly I ran the tar -zxvf on the mysqlmax.version.tar.gz, rebooted the system, then re-ran safe_mysqld --user=root. Mark - Original Message - From: Andy Cheng [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, March 10, 2002 10:01 AM Subject: Mysql installation. Help! Hi all, I got this error message when trying to connect to mysql at the shell command: Error 2002:Can't connect to local MySql server through socket '/var/lib/mysql/mysql.sock There is no mysql.sock in the /var/lib/mysql directory. Did I miss some thing in the mysql installation? Where could I find the mysql.sock? I install mysql that came with redhat 7.2. Thank for the help. _ Join the world's largest e-mail service with MSN Hotmail. http://www.hotmail.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: databases under users dir
I am glad you asked that. I think for my application, I am going to set up a blank set of tables in the database, and as a new user subscribes, simply move the blank database into their personal directory, that way I can keep all of their data segregated from other users. It may take addition physical disk space, but it would simplify my management dramatically. Thank you for that question. Mark - Original Message - From: Andreas Frøsting [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, March 09, 2002 5:07 PM Subject: RE: databases under users dir Hi, Anyone know if its possible to have mysql databases under $HOME for users. I am running RH7.2 and have virtualhosts under apache 1.3.22 so i am hoping i can put databases under each user account in order to control (quota's) etc. You can put them under each users homedir and symlink to them. I've used that method a couple of times where I had some pretty large tables taking up too much space on a particular partition. Remember to shut down mysql before moving the databases and remember to preserve ownership and rights to the files. :wq file://andreas http://phpwizard.dk (in Danish only) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: problem in mysqi
mysqladmin was installed in /usr/bin on my system. or do a locate mysqladmin that will tel ya where it is Mark - Original Message - From: Jianping Zhu [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, March 07, 2002 11:37 PM Subject: problem in mysqi I downloaded the the qpl MySQL-VERSION.i386.rpm and installed in redhat 7.2 sucessfully. but I find i can not use command like BINDIR/mysqladmin version to test the server because the file mysqladmin is not there. And I can not find bidir/mysqlshow bindir/mysql Do I have to install MySQL-client-VERSION.i386.rpm ,MySQL-bench-VERSION.i386.rpm inorder to get the missing files. Any suggestions appreciated. Jianping Zhu Department of Computer Science Univerity of Georgia Athens, GA 30602 Tel 706 5423900 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql on Linux
I know in at least 2 e-mails I did indeed mention that I executed safe_mysqld -u root, So I did it using your syntax, safe_mysqld --user=root, I had the same text returned which again said the following. Starting mysqld daemon with databases from /var/lib/mysql 020305 17:46:10 mysqld ended I presume that means that mysqld ended Basically the mysql started then abruptly stopped. Again the error in the ONLY error log linux.err said the exact same text that was displayed on my screen, making that no help. There is no mysql.sock on my system because the server is not running, anyone have any REAL ideas? The documentation is of NO help whatsoever and I am getting very frustrated with it. Trying mysqp -u root -ppassword was a desperate attempt to try it another way. As I have done numerous different ways. I don't know how many different ways I can try to get mysqld daemon running. Mark - Original Message - From: Steven Roussey [EMAIL PROTECTED] To: 'Mysql' [EMAIL PROTECTED] Sent: Tuesday, March 05, 2002 8:14 PM Subject: Re: mysql on Linux When I execute mysqld -u root -p password I am presented with the default variables. The manual says to use safe_mysqld to properly start mysqld. Also, --user=root is clearer for that option. And, what are you doing with -p password in starting the daemon? This is not an option, it is an error. http://www.mysql.com/doc/s/a/safe_mysqld.html Sincerely, Steven Roussey http://Network54.com/?pp=e - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql on Linux
The /var/lib/mysql contains the following files: linux-bin.001 linux-bin.002 linux-bin.003 linux-bin.004 linux-bin.005 linux-bin.006 linux-bin.007 linux-bin.008 linux-bin.009 linux-bin.index linux-bin.err the directory mysql the directory test directory mysql contains columns_priv.MYD columns_priv.MYI columns_priv.frm db.MYD db.MYI db.frm func.MYD func.MYI fun.frm host.MYD host.MYI host.frm tables_priv.MYD tables_priv.MYI tables_frm user.MYD user.MYI user.frm Directory test contains nothing When I remove all the files and recreate the directory using mysql_install_db then follow the directions for installing the privileges I get the same files, and the same errors. I am unable to use mysqladm create databasename since the mysql daemon is not running. It is my understanding that the database it is looking for is the permission files located in the /var/lib/mysql directories. Mark Mark - Original Message - From: Steven Roussey [EMAIL PROTECTED] To: 'Intrex' [EMAIL PROTECTED] Cc: Mysql [EMAIL PROTECTED] Sent: Wednesday, March 06, 2002 1:07 PM Subject: RE: mysql on Linux Starting mysqld daemon with databases from /var/lib/mysql 020305 17:46:10 mysqld ended This is written by safe_mysqld. It seems that mysqld was never started successfully. I've had this issue before. Every time it was a permissions issue. When I execute mysqld -u root -p password I am presented with the default variables. Which are? Also, what is in /var/lib/mysql? Sincerely, Steven Roussey http://Network54.com/?pp=e - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Error 2002 can't connect to MySQL server through socket /var/lib...
Funny I still have the same exact problem Egor does. I start mysql with safe_mysqld, same only server just ends. I do safe_mysqld nothing, I use mysqld -r root -p password Nothing I do, that is listed helps. I still have no mysql.sock, and the server never starts. Mark - Original Message - From: Egor Egorov [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, March 05, 2002 11:00 AM Subject: Error 2002 can't connect to MySQL server through socket /var/lib... dlyles, Tuesday, March 05, 2002, 4:54:30 AM, you wrote: d This is the message I am getting. I am currently running MySQL (or trying d to) on a Cobalt Raq3. Is your MySQL server running? d I recently uninstalled and reinstalled, but am unable d to remove this message. I can't start mysql or do anything. That's the d message I keep getting. Any ideas? If your MySQL is not running, you should start mysqld. If your MySQL server is running then you should check location of the socket file and check the socket path in your my.cnf file. Check your privileges on the socket file and on the dir that contains socket file. You can find the description of this error at: http://www.mysql.com/doc/C/a/Can_not_connect_to_server.html Please also tell us, how exactly did you installed MySQL on Cobalt server as there are some specific details. Have you compiled MySQL by yourself or took a binary distribution? -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql on Linux
Not to be sarcastic, but Pointing us all to ducumentation I HAVE READ 100 TIMES is NO help. I have read this file, I have used the appropriate .tar.gz, I have reinstalled, I have used the most current RPM's How about contributing something USEFUL, like a REAL answer, that anyone can follow. No cryptic mumbo jumbo, no PhD CRAPOLA. I mean REALLY. Mark - Original Message - From: Jorge del Conde [EMAIL PROTECTED] To: 'Manish Mehta' [EMAIL PROTECTED]; 'mysql' [EMAIL PROTECTED] Sent: Tuesday, October 09, 2001 1:48 AM Subject: RE: mysql on Linux Hi, Download the binary distribution that suits your system and read the INSTALL-BINARY file. Also, make sure the online documentation at http://www.mysql.com/documentation/index.html Regards, Jorge For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Jorge del Conde [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Mexico City, Mexico ___/ www.mysql.com -Original Message- From: Manish Mehta [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 09, 2001 12:34 AM To: mysql Subject: mysql on Linux Hello I want to install mysql on Linux. What are the basic step followed at the time of installation. pl. gave any suitable idea. Manish Mehta E-mail: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql on Linux
Ok. SuSE 7.3 Digital HiNote VP745 mysql Ver 11.17 Distrib 3.23.49a for pc-linux-gnu Prior to completely reinstalling my SuSE system, I was running mysql 3.23.47 for SuSE I have installed the .tar.gz and followed those instructions I have installed the RPM's using the -i, and also installed the RPM's using Yast1 package installer. Each time I have reformatted my system and re-installed in order to insure I did not have stray variables hanging around from the previous installation. When I execute mysqld -u root -p password I am presented with the default variables. When I execute safe_mysqld the following message is given Starting mysqld daemon with databases from /var/lib/mysql 020305 07:36:44 mysql ended I have insured that the mysql_install_db has indeed placed the permission databases in that directory, and that the variables listed in the my.cnf are indeed correct. After starting the safe_mysqld and trying to run mysqladmin create databasename I get the message: mysqladmin:connect to server at 'localhost' failed error: 'Can't connect to MySQL server through socket '/var/lib/mysql/mysql.sock' (2)' Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists! Running locate mysql.sock returns no such file, which would be correct since the mysqld daemon never started. has anyone had this particular problem. I can assure you I have followed the instructions in the documentation I have been repetedly poited to numerous times. What I am also sure, is that the documentation is also more than likely 'assuming' something that is NOT in the docs. Any ideas what I am missing? I do not know what I am missing here, that is causing the - Original Message - From: Scott Helms [EMAIL PROTECTED] To: 'mysql' [EMAIL PROTECTED] Sent: Tuesday, March 05, 2002 6:54 PM Subject: Re: mysql on Linux Mark, This probably won't get you the response you wanted. How about letting us know where you have gotten to and where things seem to be breaking. A generalized request for what do I do often recieves little or no help. Some basic system information would also be much appreciated; what distro are you using, what type of hardware PPC, Intel, etc. Scott - Original Message - From: Intrex [EMAIL PROTECTED] To: Jorge del Conde [EMAIL PROTECTED]; 'Manish Mehta' [EMAIL PROTECTED]; 'mysql' [EMAIL PROTECTED] Sent: Tuesday, March 05, 2002 6:23 PM Subject: Re: mysql on Linux Not to be sarcastic, but Pointing us all to ducumentation I HAVE READ 100 TIMES is NO help. I have read this file, I have used the appropriate .tar.gz, I have reinstalled, I have used the most current RPM's How about contributing something USEFUL, like a REAL answer, that anyone can follow. No cryptic mumbo jumbo, no PhD CRAPOLA. I mean REALLY. Mark - Original Message - From: Jorge del Conde [EMAIL PROTECTED] To: 'Manish Mehta' [EMAIL PROTECTED]; 'mysql' [EMAIL PROTECTED] Sent: Tuesday, October 09, 2001 1:48 AM Subject: RE: mysql on Linux Hi, Download the binary distribution that suits your system and read the INSTALL-BINARY file. Also, make sure the online documentation at http://www.mysql.com/documentation/index.html Regards, Jorge For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Jorge del Conde [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Mexico City, Mexico ___/ www.mysql.com -Original Message- From: Manish Mehta [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 09, 2001 12:34 AM To: mysql Subject: mysql on Linux Hello I want to install mysql on Linux. What are the basic step followed at the time of installation. pl. gave any suitable idea. Manish Mehta E-mail: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com
Re: mysql on Linux
I do have a mysql user, and have used the commands to assigne rights for the mysql user per the instructions. I have no hostname.err, only linux.err which displays the exact same errors I typed out. Mark - Original Message - From: James Montebello [EMAIL PROTECTED] To: Intrex [EMAIL PROTECTED] Cc: Scott Helms [EMAIL PROTECTED]; 'mysql' [EMAIL PROTECTED] Sent: Tuesday, March 05, 2002 10:59 AM Subject: Re: mysql on Linux On Tue, 5 Mar 2002, Intrex wrote: Ok. SuSE 7.3 Digital HiNote VP745 mysql Ver 11.17 Distrib 3.23.49a for pc-linux-gnu Prior to completely reinstalling my SuSE system, I was running mysql 3.23.47 for SuSE I have installed the .tar.gz and followed those instructions I have installed the RPM's using the -i, and also installed the RPM's using Yast1 package installer. Each time I have reformatted my system and re-installed in order to insure I did not have stray variables hanging around from the previous installation. When I execute mysqld -u root -p password I am presented with the default variables. When I execute safe_mysqld the following message is given Starting mysqld daemon with databases from /var/lib/mysql 020305 07:36:44 mysql ended What does the error log say at this point? It probably has a lot more detail on exactly what caused it to end. This log is probably in /var/lib/mysql/hostname.err (this is the default behavior). Possible problems are there is no mysql user, or the data directory or the mysql table isn't owned by the mysql user. This will be spelled out clearly in the error log. james montebello - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MS-DOS Window
As a DOS guy trying to learn linux here ya go At your dos window type the following: command you want and options to get help then Greater Then Sign then ourput path and filename, Or output device like LPT1 for printer. Examples would be; mysqladmin commands.txt The above command should put the commands into a file called commands.txt mysqladmin c:\commands\commands.txt The above command should put the commands into a directory c:\commands, providing that diectory exists and a file called commands.txt mysqladmin lpt1: will output the commands to the printer. I hope that helps Mark - Original Message - From: Robbie Martinez [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, March 04, 2002 6:31 PM Subject: MS-DOS Window This may be a simple MS-DOS question, but I'm a UNIX guy and am pretty clueless... I'm trying to capture some mysql command output, but my DOS screen runs out of space. In other words, the data goes beyond what I can scroll up to get. Is there any way for me to either: (1) Redirect output from mysql commands to a file (2) Create a session typescript of mysql (3) Increase the DOS window's scroll memory to a very large size (so I don't lose my data on my screen). Thanks, - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql.sock
Ok here it is. I get that annoying error. ERROR 2002: Can't connect to local MySQL server through socket /var/lib/mysql/mysql.sock (111) Ok now I DO NOT have a mysql.sock anyplace on my system. I have downloaded the stable .tar.gz and unzipped it and still do not have a mysql.sock Somepleaze tell me how to create it, or what to pu in it. Please DO NOT tell me about changing paths and stuff, I have done that till i am blue in the face. Or please e-mail me a copy of a mysql.sock. I am running SuSE 7.3 and mysql version Ver 11.15 Distrib 3.23.41 I also have the current 3.23.49a. any help would be appreciated. Mark - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL Backup and Recovery
Having worked with Oracle, and MS SQL databases, the only backup/recovery I usually deal with after the admins have their dumpdb run to a secondary transaction database is tape backup of some form. Most of the sites I have worked with however use 3 disk mirrors, and disk cloning, and disk snapshots every so often as their needs demand. The key they find is the brief database lock, and the quiessing of the databases just prior to the spanshot or breaking off of the clone allowing for the backup with nor performance degradation of their active database. I don;t know your budjet or application or even if I am making any sense, but this is how we have been working the issue of backups of databases. Mark - Original Message - From: Jeremy Zawodny [EMAIL PROTECTED] To: Chetan Lavti [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Saturday, March 02, 2002 9:31 PM Subject: Re: MySQL Backup and Recovery On Fri, Mar 01, 2002 at 09:26:36AM +0530, Chetan Lavti wrote: Hi, I am planning to have MySQL database backup and recovery from the web interface. Is it possible to do this. If yes, then what procedure I should follow. If anybody have any idea about this then please, do help me. It's our requirement. Backup and recovery is a common topic on this list. Have you scanned the archives yet? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.47-max: up 23 days, processed 764,260,032 queries (376/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql.sock
Ok, I think I have mentioned this like 3 times already. there is no mysql.sock anyplace on my system. I need a mysql.sock file. I have set the symbolic links. Originally they were in the /var/lib/mysql directory, then I changed it to the /tmp directory per so many peoples advice. not mater what I HAVE NO mysql.sock file. I need a mysql.sock file. Can someone send me a mysql.sock file so I can place the mysql.sock file in the appropriate directory of what is in the myysql.sock file so I can make one myself. Mark - Original Message - From: Mike [EMAIL PROTECTED] To: MySQL [EMAIL PROTECTED] Sent: Saturday, March 02, 2002 11:23 PM Subject: RE: mysql.sock You need to create a symbolic link ln -s /tmp/mysql.sock /var/lib/mysql/mysql.sock or ln -s /tmp/mysql.sock mysql.sock Do a search to find where it's at first thoughG locate mysql.sock Mike -Original Message- From: Intrex [mailto:[EMAIL PROTECTED]] Sent: Saturday, March 02, 2002 8:14 PM To: MySQL Subject: Re: mysql.sock Well, my MySQL server is not running. I have followed all of the instructions to install, and no matter what commane I run the server does not run, and I get the error I mentioned below. locate mysql.sock provides nothing. I am just about to go back to Win2k and IIS. God the though of that makes me cringe. Running mysqladmin ping provides this message: mysqladmin: connect to server at 'localhost' failed error: Can't connect to local MySQL server socket through socket 'tmpmysql.sock' (2) Check that mysql is running ans that the socket: 'tmp/mysql.sock' exists! I take it that when the mysql server is running that this file is created, and that this file is needed to get the server running. Seems like the chicken and the egg routine. Can't have one without the other, and visa versa. I am in a quandry as to how to get this silly thing going. what am I missing. I have gone even to the point of trashing my whole SuSE system and reinstalling. All to no avail. I even installed Red Hat 7.0 and installed the mysql on it and still recieve the same errors. I am sure my problem is not an original one. I do appreciate any help in this, since this is my first experience with mysql, and I am a relative Linux noob. Mark - Original Message - From: Jeff Kilbride [EMAIL PROTECTED] To: Intrex [EMAIL PROTECTED]; MySQL [EMAIL PROTECTED] Sent: Saturday, March 02, 2002 9:33 PM Subject: Re: mysql.sock First of all, are you sure MySQL is running? The mysql.sock file only appears when the server is running. Run the following command on the command line to make sure: ps awx | grep mysqld You should see one line with safe_mysqld in it, and at least a few lines with mysqld in them. If not, you need to start the server. Once the server is running, if you have superuser privileges on your system, you can run: updatedb This will take a few seconds and re-index all the files on your system, so you can run: locate mysql.sock to find out where the server is creating the socket. This command should give you the path to the mysql.sock file. Once you have that, look in your my.cnf file for lines like: [client] port= 3306 socket= /path/to/mysql.sock [mysqld] port= 3306 socket= /path/to/mysql.sock The socket variable is where MySQL *thinks* your mysql.sock should be -- not necessarily where it is. Change these lines to match the path returned by the locate command and things should work. If you don't have superuser access and you can't run updatedb, the most likely places for mysql.sock are your installation directory (where the data files are stored), and: /var/tmp/mysql.sock /var/lib/mysql/mysql.sock At least on RedHat -- I'm not sure about SUSE, but it's worth a look. Check these places and see if it exists. If you find it, update your my.cnf file with the correct path. Good luck! --jeff - Original Message - From: Intrex [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, March 02, 2002 5:26 PM Subject: mysql.sock Ok here it is. I get that annoying error. ERROR 2002: Can't connect to local MySQL server through socket /var/lib/mysql/mysql.sock (111) Ok now I DO NOT have a mysql.sock anyplace on my system. I have downloaded the stable .tar.gz and unzipped it and still do not have a mysql.sock Somepleaze tell me how to create it, or what to pu in it. Please DO NOT tell me about changing paths and stuff, I have done that till i am blue in the face. Or please e-mail me a copy of a mysql.sock. I am running SuSE 7.3 and mysql version Ver 11.15 Distrib 3.23.41 I also have the current 3.23.49a. any help would be appreciated. Mark - Before posting, please check: http://www.mysql.com/manual.php