index
hi lists 1. does the indexes require additional storage other than the table space storage. 2. is there any performance difference will be there, if we go for innodb_file_per_table. Normal 0 false false false EN-US X-NONE AR-SA Thanks Kind Regards, TRIMURTHY
Re: Dumping drupal databases
* 小刀 13488684...@163.com [121029 18:43]: You can the the /etc/my.cnf and file the parameter about the data_dir I'm sorry. I don't understand. I might try cp -p -r, but need a second opinion. BTW: No need to CC me. thanks -- Tim tim at tee jay forty nine dot com or akwebsoft dot com http://www.akwebsoft.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: Dumping drupal databases
Is it the question that how to dump drupal database ? then here is one of the option. You can look at the details mentioned in the default/settings.php file and use mysql to export the data. Or the other option to install a module in Drupal Backup Restore which can you just login thru drupal and you can take a dump of the existing database if you have admin credentials. *thanks regards,* *__* Kishore Kumar Vaishnav *___ RAILSFactory ___* On Tue, Oct 30, 2012 at 9:42 PM, Tim Johnson t...@akwebsoft.com wrote: * 小刀 13488684...@163.com [121029 18:43]: You can the the /etc/my.cnf and file the parameter about the data_dir I'm sorry. I don't understand. I might try cp -p -r, but need a second opinion. BTW: No need to CC me. thanks -- Tim tim at tee jay forty nine dot com or akwebsoft dot com http://www.akwebsoft.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: Dumping drupal databases
Am 30.10.2012 17:17, schrieb Hassan Schroeder: On Tue, Oct 30, 2012 at 9:12 AM, Tim Johnson t...@akwebsoft.com wrote: I might try cp -p -r, but need a second opinion. If you want to dump one or more databases, presumably you know the name(s); just use the mysqldump utility. Copying files is not the optimal way to save your data for most use cases. if it are MyISAM tables it is the best way because all data are in a folder with the database name - i never in my life used a dump to migrate mysql-databases while started with MySQL-3.x long years ago and moved them between Linux, Windows and MacOSX and we speak about some hundret databases with 5000 tables signature.asc Description: OpenPGP digital signature
Re: Dumping drupal databases
* Reindl Harald h.rei...@thelounge.net [121030 08:25]: if it are MyISAM tables it is the best way because all data are in a folder with the database name - i never in my life used a dump to migrate mysql-databases while started with MySQL-3.x long years ago and moved them between Linux, Windows and MacOSX and we speak about some hundret databases with 5000 tables Clearly, I have failed to pose my question clearly, because the responses indicate that I have not been understood, so I will try again: * mysqldump does not recognize the drupal databases! Example : linus:prj tim$ mysqldump event -hlocalhost -utim -pXX event.sql mysqldump: Got error: 1049: Unknown database 'event' when selecting the database mysql does not find the drupal databases! PHPMyAdmin does not find the drupal databases! That is to say that my invocation of the applications above fails to find the drupal databases! * I remain as dumb as ever, but I hope I have made myself clearer regards -- Tim tim at tee jay forty nine dot com or akwebsoft dot com http://www.akwebsoft.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: Dumping drupal databases
Am 30.10.2012 17:34, schrieb Tim Johnson: * Reindl Harald h.rei...@thelounge.net [121030 08:25]: if it are MyISAM tables it is the best way because all data are in a folder with the database name - i never in my life used a dump to migrate mysql-databases while started with MySQL-3.x long years ago and moved them between Linux, Windows and MacOSX and we speak about some hundret databases with 5000 tables Clearly, I have failed to pose my question clearly, because the responses indicate that I have not been understood, so I will try again: * mysqldump does not recognize the drupal databases! Example : linus:prj tim$ mysqldump event -hlocalhost -utim -pXX event.sql mysqldump: Got error: 1049: Unknown database 'event' when selecting the database mysql does not find the drupal databases! PHPMyAdmin does not find the drupal databases! your first message: The drupal mysql datafiles are located at /Applications/drupal-7.15-0/mysql/data as opposed to /opt/local/var/db/mysql5 for 'customary' mysql. this crap is outside your mysqldata and that is why it was suggested that you teporary change the datadir of your mysqld to /Applications/drupal-7.15-0/mysql/data or if this are only MyISAM-atbles FOR SURE you can simply move the database folders in your running mysqld-datadir typical MacOSX-style to throw things around the whole machine without any logical structure like applications in the userhome.. this is the price someone has to pay for a poor operating system without package management signature.asc Description: OpenPGP digital signature
Re: Dumping drupal databases
* Tim Johnson t...@akwebsoft.com [121030 08:37]: * I remain as dumb as ever, but I hope I have made myself clearer regards To elaborate further : See this entry from mysql --help Default options are read from the following files in the given order: /etc/my.cnf /etc/mysql/my.cnf /opt/local/etc/mysql5/my.cnf ~/.my.cnf /Applications/drupal-7.15-0/mysql/my.cnf is __not__ being read. -- Tim tim at tee jay forty nine dot com or akwebsoft dot com http://www.akwebsoft.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: Dumping drupal databases
On 10/30/2012 12:34 PM, Tim Johnson wrote: ... snip ... Clearly, I have failed to pose my question clearly, because the responses indicate that I have not been understood, so I will try again: * mysqldump does not recognize the drupal databases! Example : linus:prj tim$ mysqldump event -hlocalhost -utim -pXX event.sql mysqldump: Got error: 1049: Unknown database 'event' when selecting the database ... snip ... Your syntax is inverted. Put the name of the database at the end. mysqldump -hlocalhost -utim -pXX event event.sql If you fail to do so, you would login as the 'anonymous user' if it is still enabled on that machine and that account typically has zero privileges. Check the command-line syntax here: http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html -- Shawn Green MySQL Principal Technical Support Engineer Oracle USA, Inc. - Hardware and Software, Engineered to Work Together. Office: Blountville, TN -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: Dumping drupal databases
* Shawn Green shawn.l.gr...@oracle.com [121030 09:01]: On 10/30/2012 12:34 PM, Tim Johnson wrote: ... snip ... Clearly, I have failed to pose my question clearly, because the responses indicate that I have not been understood, so I will try again: * mysqldump does not recognize the drupal databases! Example : linus:prj tim$ mysqldump event -hlocalhost -utim -pXX event.sql mysqldump: Got error: 1049: Unknown database 'event' when selecting the database ... snip ... Your syntax is inverted. Put the name of the database at the end. mysqldump -hlocalhost -utim -pXX event event.sql If you fail to do so, you would login as the 'anonymous user' if it is still enabled on that machine and that account typically has zero privileges. You are correct of course, but that does not solve the original problem. thanks -- Tim tim at tee jay forty nine dot com or akwebsoft dot com http://www.akwebsoft.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: Dumping drupal databases
* Reindl Harald h.rei...@thelounge.net [121030 08:49]: The drupal mysql datafiles are located at /Applications/drupal-7.15-0/mysql/data as opposed to /opt/local/var/db/mysql5 for 'customary' mysql. this crap is outside your mysqldata I don't know what you mean by crap. Sorry. Actually I do ... you're about to embark on a rant about Mac. Go for it! :) and that is why it was suggested that you teporary change the datadir of your mysqld to /Applications/drupal-7.15-0/mysql/data or if this are only MyISAM-atbles FOR SURE you can simply move the database folders in your running mysqld-datadir What would you suggest as a fool-proof method to accomplish this? I hate to tweak the 'original' my.cnf, I could add a ~/.my.cnf but how would I do that without clobbering my 'non-drupal' mysql? I want to reiterate that cp -p -r might actually be the solution, but have not tried that approach in the past typical MacOSX-style to throw things around the whole machine without any logical structure like applications in the userhome.. this is the price someone has to pay for a poor operating system without package management Oh don't get me started! Grr! If truth be told, I'm a long-time linux user and new to OS X. You are preaching to the converted my friend. I'm not certain I like the way acquaire did the setup. I didn't have this problem when I played with drupal on ubuntu. Great minds run in the same gutter. -- Alaskus Curmudgeous -- Tim tim at tee jay forty nine dot com or akwebsoft dot com http://www.akwebsoft.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: Dumping drupal databases
why dont u create a softlink On Tue, Oct 30, 2012 at 11:05 PM, Tim Johnson t...@akwebsoft.com wrote: * Reindl Harald h.rei...@thelounge.net [121030 08:49]: The drupal mysql datafiles are located at /Applications/drupal-7.15-0/mysql/data as opposed to /opt/local/var/db/mysql5 for 'customary' mysql. this crap is outside your mysqldata I don't know what you mean by crap. Sorry. Actually I do ... you're about to embark on a rant about Mac. Go for it! :) and that is why it was suggested that you teporary change the datadir of your mysqld to /Applications/drupal-7.15-0/mysql/data or if this are only MyISAM-atbles FOR SURE you can simply move the database folders in your running mysqld-datadir What would you suggest as a fool-proof method to accomplish this? I hate to tweak the 'original' my.cnf, I could add a ~/.my.cnf but how would I do that without clobbering my 'non-drupal' mysql? I want to reiterate that cp -p -r might actually be the solution, but have not tried that approach in the past typical MacOSX-style to throw things around the whole machine without any logical structure like applications in the userhome.. this is the price someone has to pay for a poor operating system without package management Oh don't get me started! Grr! If truth be told, I'm a long-time linux user and new to OS X. You are preaching to the converted my friend. I'm not certain I like the way acquaire did the setup. I didn't have this problem when I played with drupal on ubuntu. Great minds run in the same gutter. -- Alaskus Curmudgeous -- Tim tim at tee jay forty nine dot com or akwebsoft dot com http://www.akwebsoft.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: Dumping drupal databases
* Kishore Vaishnav kish...@railsfactory.org [121030 08:25]: ...snip Or the other option to install a module in Drupal Backup Restore which can you just login thru drupal and you can take a dump of the existing database if you have admin credentials. OK. Use drupal directly? That makes sense. I see from http://drupal.org/node/22281 that there are backup and DB admin modules. I will take a look at them. thanks -- Tim tim at tee jay forty nine dot com or akwebsoft dot com http://www.akwebsoft.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: index
Innodb stores it's indexes internally in the datafile; they do consume storage, but that space is shared with the data. innodb_per_file will, in most cases, enhance performance in a high-concurrency environment. It also can simplify administration, and help limit your liabilities in the event of catastrophic filesystem error. - md On Tue, Oct 30, 2012 at 3:18 AM, Trimurthy trimur...@tulassi.com wrote: hi lists 1. does the indexes require additional storage other than the table space storage. 2. is there any performance difference will be there, if we go for innodb_file_per_table. Normal 0 false false false EN-US X-NONE AR-SA Thanks Kind Regards, TRIMURTHY -- - 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
Re: Dumping drupal databases
* Ananda Kumar anan...@gmail.com [121030 09:48]: why dont u create a softlink From /opt/local/var/db/mysql5/ to /opt/local/var/db/mysql5/ ??? I can try that, but I am doing things to MySQL that I have never done before and I am reluctant to risk clobbering a complex development environment that has nothing to do with drupal. After all, I am just playing with drupal. I'd welcome your elaboration or a second opinion. thanks -- Tim tim at tee jay forty nine dot com or akwebsoft dot com http://www.akwebsoft.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: Dumping drupal databases
* Hassan Schroeder hassan.schroe...@gmail.com [121030 08:25]: On Tue, Oct 30, 2012 at 9:12 AM, Tim Johnson t...@akwebsoft.com wrote: I might try cp -p -r, but need a second opinion. If you want to dump one or more databases, presumably you know the name(s); just use the mysqldump utility. Copying files is not the optimal way to save your data for most use cases. Hi Hassan : As you have probably noted, this thread has grown considerable and I did not post all issues in the OP, but the fact is: ** mysqldump, mysql, and phpmyadmin do not see the drupal DBs (presumably) because they are under a datadir that is not included in the my.cnf files that are being seached by mysql ** -- Tim tim at tee jay forty nine dot com or akwebsoft dot com http://www.akwebsoft.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: Dumping drupal databases
OP : * Tim Johnson t...@akwebsoft.com [121029 16:28]: I've recently unstalled drupal 7.15 on Mac OS X 10.7. I want to back up the mysql data for drupal. However, I can't locate those databases and tables using MySQL server or PHPMyAdmin, even if I start mysql on port 3307. The drupal mysql datafiles are located at /Applications/drupal-7.15-0/mysql/data as opposed to /opt/local/var/db/mysql5 for 'customary' mysql. I will be gone for several hours. Then I'm going to look at a drupal-specic (modular) way of doing database management before anything else. I'm an under the hood kind of guy, but when in drupal do as drupal does (perhaps). thanks for all of the replies -- Tim tim at tee jay forty nine dot com or akwebsoft dot com http://www.akwebsoft.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: Dumping drupal databases
* Tim Johnson t...@akwebsoft.com [121030 10:40]: OP : * Tim Johnson t...@akwebsoft.com [121029 16:28]: ...snip I want to back up the mysql data for drupal. However, I can't locate those databases and tables using MySQL server or PHPMyAdmin, even if I start mysql on port 3307. ...snip Then I'm going to look at a drupal-specic (modular) way of doing database management before anything else. I'm an under the hood kind of guy, but when in drupal do as drupal does (perhaps). sigh I wanted to do this in a CLI mode and that's 'cuz I'm a CLI type of fellow. But as they say : when in Rome (drupal) do as the Romans (drupals) do. So, I installed the backup_migrate module and it created a backup file of .mysql extension without any effort :) Solved. -- Tim tim at tee jay forty nine dot com or akwebsoft dot com http://www.akwebsoft.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
