Re: trying to install on RedHat 7.0 and need help
Charles, you need to be more descriptive about exactly what problem you're having. Spell out your hardware, OS, MySQL version, etc., and describe what isn't working. Charles L. Hagen [[EMAIL PROTECTED]] wrote: I cannot seem to get this database program to work correctly. I am asking for any help I can get. I need to start this asap. Charles Hagen [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
mcrypt and encrypted field length
Please see my questions below - I asked the PHP list and no-one responded. Basically I'm new to "mcrypt" and I'm trying to use mcrypt and PHP with MySQL - I'd like to encrypt a 20-character field and store the result in a MySQL column, but I'm not sure 1. what data type to make the column - varchar? 2. how big to make the column I'm testing using Triple DES encryption, and the resulting string contains all kinds of strange characters - I'm able to store the field using the PHP add_slashes function to escape a few special characters, but in the "mysql" client when I query the row containing the encrypted field, mysql displays a bunch of strange characters - I can refer to the row by the non-encrypted key although the same key does *NOT* display properly in mysql(the encrypted column must be screwing up the displayi). Anyone have any ideas how to help? TIA. -- Hardy Merrill Mission Critical Linux, Inc. http://www.missioncriticallinux.com - Forwarded message from Hardy Merrill [EMAIL PROTECTED] - Date: Mon, 26 Feb 2001 10:49:37 -0500 From: Hardy Merrill [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: [PHP] mcrypt and encrypted field length First, can anyone point me to a good "mcrypt" primer or tutorial? Second, how can I determine what type and length I should make a database field that will hold encrypted data? Is there some table somewhere which tells how long a resulting encrypted field will be based on the encryption type and/or length of the plaintext field? Example: If I have a 20 character field and want to use Triple DES to encrypt it, can I find out how long the resulting field will be - what is the longest it will be? Will the resulting encrypted field always be the same length? Should I make the data type some variation of "text" or "varchar"? TIA. -- Hardy Merrill Mission Critical Linux, Inc. http://www.missioncriticallinux.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] - End forwarded message - - 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
3.23 Online Table Maintenance?
In the 3.23 news article, at the bottom it says this: Online Table Maintenance MySQL 3.23 now incorporates many of the table maintanence features of the (previously only external) utilities `(my)isamchk' directly into the MySQL server. The use of these newly incorporated features can help to eliminate system downtime, by allowing the Database Administrator to repair damaged tables without shutting-down the MySQL server. Where can I find additional information about the table maintenance features that have now been incorporated into the MySQL server? TIA. -- Hardy Merrill Mission Critical Linux, Inc. http://www.missioncriticallinux.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
Re: 3.23 Online Table Maintenance?
What privileges does a MySQL user need to execute the CHECK TABLES command on a table? Is it possible to GRANT very limited privileges to a "chktbl" user so that all that user can do is "CHECK TABLES"? But privs that will also allow that user to CHECK TABLES on tables for *any* database in MySQL? TIA. -- Hardy Merrill Mission Critical Linux, Inc. http://www.missioncriticallinux.com Sinisa Milivojevic [[EMAIL PROTECTED]] wrote: Hardy Merrill writes: In the 3.23 news article, at the bottom it says this: Online Table Maintenance MySQL 3.23 now incorporates many of the table maintanence features of the (previously only external) utilities `(my)isamchk' directly into the MySQL server. The use of these newly incorporated features can help to eliminate system downtime, by allowing the Database Administrator to repair damaged tables without shutting-down the MySQL server. Where can I find additional information about the table maintenance features that have now been incorporated into the MySQL server? TIA. -- Hardy Merrill Mission Critical Linux, Inc. http://www.missioncriticallinux.com Hi! In the manual. Look for CHECK TABLE and REPAIR TABLE commands. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - 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: mysqldump
By "even as root", do you mean that you did something like this: $ mysqldump -u root -p db_name db_name.sql ? The "root" user *in* MySQL should have privileges to run mysqldump. Describe the situation in a little more detail if you're still having problems - like: * what is the exact mysqldump command you are trying John Jensen [[EMAIL PROTECTED]] wrote: I have an existing mysql database I am trying to back up before upgrading to 3.23 from 3.22. Both the mysqldump and mysqladmin commands tell me I am accessing as the wrong user when I execute from the bash prompt, even as root. From the mysql prompt, these commands are not recognized at all. I am not finding the manual at all helpful to get around this problem. I have even tried telneting in as user "mysql", but that doesn't work either. Any ideas? John Jensen 520 Goshawk Court Bakersfield, CA 93309 661-833-2858 - 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: Need help with Install of MySQL
Matt, I'm fairly new to MySQL myself, but it sounds like your mysqld is not starting up when you issue safe_mysqld. Instead of invoking safe_mysqld directly, find the "mysql.server" file that got installed with mysql, and start mysqld with that by doing something like: cd /dir/to/mysql.server ./mysql.server start There's quite a bit more to consider, like what user you want to start the server as, but try that first and see if that will start the server for you. HTH. -- Hardy Merrill Mission Critical Linux, Inc. http://www.missioncriticallinux.com Matt Davis [[EMAIL PROTECTED]] wrote: I am new to MySQL and have just installed the MySQL rpm files to my Linux box. I have run "mysql_install_db" with no problems and I have then run "safe_mysqld " this comes up with the messsage "starting mysql daemon with databses from /var/lib/mysql mysqld daemon ended" I assumed that this was corrected and then ran "mysqladmin version" to which i recieved the following error message "can't connect to local mysql server through socket /var/lib/mysql/mysql.sock (111) check that mysql is running and that the socket /var/lib/mysql/mysql.sock exists" I can not find any mysql processes running when I type "ps" and I cannot find any sock files anywhere. What am i doing wrong can somebody please please help. Thanks Matt Davis. - 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: --skip-locking on Redhat 6.1 Linux
Rolf Hopkins [[EMAIL PROTECTED]] wrote: Firstly, I'm curious as to why you need --skip-locking in the first place. I'm not sure that I do - I just thought that if I instead used --enable-locking that this problem of update logs getting confused with flush-logs might(?) go away. But I haven't been able to find any definite documentation that advises whether you can/should run MySQL on Linux without the default(on Linux) --skip-locking, and what the issues (pros/cons) are surrounding that. The basic problem is MySQL seems to be running well on Redhat 6.1 Linux *with* the default --skip-locking, except for this update log confusion problem that I see occassionally. And now that I've put the sleep in after the mysqladmin flush-logs, I can't get the confusion to happen any more - maybe I've solved the problem??? Here's my basic backup strategy * mysqldump once a week * mysqladmin flush-logs once an hour(?), and save the inactive (older) logs to a backup directory for that week * I'd like to work in a "myisamchk" once a day(?), but the documentation says not to do this while running --skip-locking unless you bring the server down * Again, I thought that --enable-locking might solve this problem, and allow me to run myisamchk when the server is up - would it? Would you do this differently? Or does this seem like a reasonable strategy? Please reply - it's great to finally(after posting this 3 times, and reading all the related documentation I could find) get a response. Thank you very much! -- Hardy Merrill Mission Critical Linux, Inc. http://www.missioncriticallinux.com Now that I know what you are trying to achieve, I can honestly say I'm not sure. I'd have to read the manual for more detail on how flush-logs interact with table locking etc. I presume your daemon, that's accessing the DB, is a cron job. Can you time it so that your flush-logs occur between this daemon process? - Original Message - From: "Hardy Merrill" [EMAIL PROTECTED] To: "Rolf Hopkins" [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, February 07, 2001 23:15 Subject: Re: --skip-locking on Redhat 6.1 Linux Rolf, I'm invoking safe_mysqld with --skip-locking and --log-update=update_log, among other options. If I run mysqladmin flush-logs while database updates are occurring, the update logs sometimes get confused - the scheme I have is basically mysqladmin flush-logs mv name_of_old_update_log backup_dir and using this scheme I've seen a few different types of update log confusion, but here was one: current update log name: update_log.100 when I ran mysqladmin flush-logs while updates were occurring, the result was that the update log that was moved to backup_dir had name "update_log.100", and the new update log that got created in the MySQL data directory had exactly the same name(update_log.100). I have a daemon writing INSERT's and UPDATE's very regularly to the MySQL database, so I don't want to take the MySQL server down if I can help it, but I would like to run flush-logs on a regular basis so I can have checkpoints of database updates to save off - is there a way for me to lock the tables(or the whole database) in the script *before* doing the mysqladmin flush-logs, to prevent update log confusion? Do you know of a way to solve this update log confusion? I did notice that when I inserted a sleep 1(or 2) between the mysqladmin flush-logs and the "mv" that I haven't been able to "make" the update-logs get confused, but I'm not very confident that this is "the" right solution. Please help. Thanks. Hardy Merrill Mission Critical Linux, Inc. http://www.missioncriticallinux.com Rolf Hopkins [[EMAIL PROTECTED]] wrote: can: yes should: That's up to you but personally I wouldn't - Original Message - From: "Hardy Merrill" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, February 07, 2001 3:31 Subject: --skip-locking on Redhat 6.1 Linux Can/should MySQL be started *without* --skip-locking on Redhat 6.1 Linux? TIA. -- Hardy Merrill Mission Critical Linux, Inc. http://www.missioncriticallinux.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/
--skip-locking on Redhat 6.1 Linux
Can/should MySQL be started *without* --skip-locking on Redhat 6.1 Linux? TIA. -- Hardy Merrill Mission Critical Linux, Inc. http://www.missioncriticallinux.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
update log sequence
I'm running mysql with --log-update=update_log with no extension, so every time I flush the logs I get the next sequential number appended as an extension to the new update_log file. If I flush the logs regularly every day, that sequence number will continue to grow - is there any way to reset the update_log sequence number back to .000? How big will it grow? Will it ever recycle itself? TIA. Hardy - 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: need some help here...
Just my opinion, but I prefer numeric keys that the users *can't* see, to alpha keys that the users can see: 1. numeric keys are faster 2. using numeric keys that the user can't see allows you to open up(for UPDATE) ALL the fields that the user can see including a field like School Name. Problem with alpha School Name: If you allow the users to change the school name, you'd have to change *ALL* occurrences of the old school name to the new school name - in all tables/rows that reference the old school name - could be a big programming effort. If you don't allow the users to change the school name, they might be unhappy - or maybe you allow users to submit a form saying they want to change school name from a to b, and you write a program which goes through the database changing every occurrence of a to b. Again, a lot of work, and users who are probably unhappy. Solution: Instead of having the School Name be your primary key, have a field called school_id that the users can't see or update - once assigned to a school, that school_id is the primary key to that school's info forever. If another table/record needs to refer to a particular school, you store the school_id in that table/record, instead of storing the school name. Since the users can never update the school_id, you don't have to worry about writing extra code to update all the occurrences of a to b - you can then allow users to update the school name field without affecting the key - the school name is just another data field. This may not be the best example for me to demonstrate why I think numeric keys are better - maybe in this case the School Name never changes for any of the schools. But if it could change, then numeric keys could be the answer. MySQL auto-increment fields are great for this, and Oracle has a similar type of field called a "sequence". Where it makes sense, my preference is to use an auto-increment INTEGER field as the primary key to a table. Keeping the numeric keys used for basic retrieval separate from the user viewable/updatable fields makes for a smaller, less-complex, and more flexible program. Again, just my opinion. HTH. -- Hardy Merrill Mission Critical Linux, Inc. http://www.missioncriticallinux.com John Jensen [[EMAIL PROTECTED]] wrote: Think of the tables in your database as linked sets. I have a college database where school description as info associated in three other tables, allowing one school description, one or more contacts, requirements for one or more programs, and each program has one or more degrees associated, in the last table. In each table, the School name is replicated, serving as the primary key in only the first. The primary key of the second is replicated in the third, and so on. Only degrees have a number as the key, with School name and the key of the previous table entered as fields, to link everything together. How you use tables will be defined by how your data needs to be organized. Understanding your data needs is your first step. On 5 Feb 2001, at 10:55, Chris Toth wrote: I'm having a extremely hard time grasping the concept of multiple tables. So far, I've been using just one table when designing a database. But now I have to design a database for a trouble-ticket system for our department. I've written out the design of the tables, but the part I don't understand is how the tables relate to each other. Do I need to use foreign keys? But if I do, I thought MySQL didn't support foreign keys? BTW, I've read most of the O'rielly mSQL/MySQL book and couldn't find my answers. Just in case it matters, I'm going to have one table full of faculty info, one of staff info, one for the trouble ticket itself, and possibly one for actions performed on the trouble ticket. John Jensen 520 Goshawk Court Bakersfield, CA 93309 - 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 -- Hardy Merrill Mission Critical Linux, Inc. http://www.missioncriticallinux.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
incremental backups?
Are incremental backups possible in MySQL? I haven't seen any reference to "incremental" in the mysqldump or anywhere else for that matter. TIA. -- Hardy Merrill Mission Critical Linux, Inc. http://www.missioncriticallinux.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