innodb recovery
Hello! I got all data files (ibdata1, ib_logfile, etc) recovevered from mine old Debian 3.1 box (and i dont know MySQL version :( ). I want to get that DB running again. Can i copy these files to newer version of MySQL, and if i can - how? Any commands, any parameters? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Record old passwords ?
On Wednesday 20 January 2010 01:10, Daevid Vincent wrote: -Original Message- From: John Meyer [mailto:john.l.me...@gmail.com] Sent: Monday, January 18, 2010 5:04 PM To: co...@obviouslymalicious.com; mysql@lists.mysql.com Subject: Re: Record old passwords ? Although, on an OT, forcing people to not use a password that they have recently used is a bad idea. What they eventually do is go with something like hometown01 hometown02, etc. Or worse, they start writing down their passwords which is a whole other security problem. Amen to that. At my work, they require a password change every month, but they store the last 6 passwords you used, so I do exactly what you say -- I have a logbook and store the same 6 passwords in it and just cycle them. Other tricks I do, is use a pattern on the keyboard and just shift it. None of this is secure, and I totally know it (although I'm not picking secret or something as my PW, it's random letters/numbers/symbols). But I hate the policy and I'm kind of a rebel like that. ;-p Several years ago I worked at a place where users had to change their windows password every N month and they kept a long history log of used password. My solution to this was to write a program that asked me for my current password and how many previous used password the system remembered. The program worked like this: for (n = 0; no_of_stored_password n; n++) { set_password(random_generated_password); do_a_short_sleep(); } set_password(original_password); ... and the problem was solved :) -- Jørn Dahl-Stamnes homepage: http://www.dahl-stamnes.net/dahls/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
ANN: DBForms from MS Access to PHP + MySQL v3.0.0. release!
DMSoft Technologies is glad to announce the release of DBForms from MS Access to PHP + MySQL v3.0.0. DBForms from MS Access to PHP + MySQL allows you to convert MS Access forms to PHP driven WEB pages and Microsoft Access tables to MySQL database. This converter combines the strengths of previous versions and supports new features that will improve data processing and increase conversion speed. Here is a change log: - MS Access queries conversion support - Insert, Update and Drop functionality are added in WEB pages - DataBase engine is improved - PHP engine is improved Find more info about DBForms from MS Access to PHP + MySQL 3.0.0 at: http://www.dbconvert.com/convert-accessforms-to-web-mysql.php You are welcome to download DBForms from MS Access to PHP + MySQL 3.0.0 DEMO at: http://www.dbconvert.com/downloads/dbforms_php_mysql.zip To order or upgrade DBForms from MS Access to PHP + MySQL now visit the following page: http://dbconvert.com/order.php Your feedback is highly appreciated. Best regards, Best regards, Dmitry Narizhnykh, http://www.dbconvert.com Smart database conversion / synchronization tools -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
installing mysql 5.1.37 in ubuntu 8.10
Hi, i am using ubuntu 8.10, i installed mysql from aptitude(version is 5.0.67-0ubuntu6). My db creation sql script is working correctly in version, But my client complaining its giving errors in mysql 5.1.37 version. Could any one guide me to install mysql 5.1.37 in my ubuntu 8.10 OS. Thanks in advance. Best Regards, Mohan. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
parameter being overwritten
im trying to setup mysql slave but the things is it wont start because of this errror: -- ERROR 1200 (HY000): The server is not configured as slave; fix in config file or with CHANGE MASTER TO after some testing.. i saw the server-id = 0 through show variables like 'server_id' went to check server-id parameter in /etc/my.cnf grep server-id /etc/my.cnf #server-id = 2 server-id = 2 -- its good.. ls -l ~/my.cnf -- file not found.. print_defaults mysqld result --server-id=2 -- its good but again show variables like server_id is showing 0 what i had to do is set global parameter in mysqld cli w/c is not a good thing.. additional info: Default options are read from the following files in the given order: /etc/my.cnf ~/.my.cnf /etc/my.cnf is there anyway to trace why server-id = 0?
Re: parameter being overwritten
If the server-id in your variables is not what you have in your config, then either: a) that is not the config file mysql is using or b) your build of mysql is seriously broken. If you are able toget the server configured correctly, there still will be the matter of synchronizing the data from the master and then issuing the' CHANGE MASTER TO..' statement as indicated. You have read this? http://dev.mysql.com/doc/refman/5.1/en/replication-howto.html On Wed, Jan 20, 2010 at 12:43 PM, Jerome Macaranas jerom...@gmail.com wrote: im trying to setup mysql slave but the things is it wont start because of this errror: -- ERROR 1200 (HY000): The server is not configured as slave; fix in config file or with CHANGE MASTER TO after some testing.. i saw the server-id = 0 through show variables like 'server_id' went to check server-id parameter in /etc/my.cnf grep server-id /etc/my.cnf #server-id = 2 server-id = 2 -- its good.. ls -l ~/my.cnf -- file not found.. print_defaults mysqld result --server-id=2 -- its good but again show variables like server_id is showing 0 what i had to do is set global parameter in mysqld cli w/c is not a good thing.. additional info: Default options are read from the following files in the given order: /etc/my.cnf ~/.my.cnf /etc/my.cnf is there anyway to trace why server-id = 0? -- - michael dykman - mdyk...@gmail.com May the Source be with you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: innodb recovery
Hi Johny Do you have the my.cnf configuration file ?? that can simplify things. Carlos On 1/20/2010 3:32 AM, Johny Brawo wrote: Hello! I got all data files (ibdata1, ib_logfile, etc) recovevered from mine old Debian 3.1 box (and i dont know MySQL version :( ). I want to get that DB running again. Can i copy these files to newer version of MySQL, and if i can - how? Any commands, any parameters? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: innodb recovery
Hi John, The data files will give you some informations like log_file_size, mutliple tablespace is being used or not. Although my.cnf can help you a lot. With the above information, use it with newer version of mysql. Krishna On Wed, Jan 20, 2010 at 3:02 PM, Johny Brawo lydyh...@gmail.com wrote: Hello! I got all data files (ibdata1, ib_logfile, etc) recovevered from mine old Debian 3.1 box (and i dont know MySQL version :( ). I want to get that DB running again. Can i copy these files to newer version of MySQL, and if i can - how? Any commands, any parameters? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=prajapat...@gmail.com