Re: Dumping drupal databases
* Reindl Harald [121031 17:22]: > > > Am 01.11.2012 01:54, schrieb Tim Johnson: > > * Reindl Harald [121031 08:12]: > >> you MUST NOT use "localhost" if you want to connect to > >> a different mysqld-port because "localhost" is unix-socket > >> > >> mysql -h 127.0.0.1 --port=3307 -u -p > > I get "access denied" when I do that. > > thanks > > don't get me wrong - but do you have any clue about > what you are doing? Did you not note that I have a solution? I am clearly aware of the options that you outline below. Let it go. You are ahead of me on your knowledge base and clearly you are trying to help everybody. I no longer need your help so don't waste your time on me. (this time) :) Maybe I will need you help again some day. In the meantime, good luck and keep up the good work! -- 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 01.11.2012 01:54, schrieb Tim Johnson: > * Reindl Harald [121031 08:12]: >> you MUST NOT use "localhost" if you want to connect to >> a different mysqld-port because "localhost" is unix-socket >> >> mysql -h 127.0.0.1 --port=3307 -u -p > I get "access denied" when I do that. > thanks don't get me wrong - but do you have any clue about what you are doing? replace with the username drupal is using enter the password drupal is using you got MANY options in thsi thread * let point your default mysqld-datadir to the one the drupal setup used and export the data, after that restore /etc/my.cnf as it is now * stop ANY mysqld instance and copy the db-folder to your used instance * connect to the instance as asid with 127.0.0.1 if you are not able or/and willing to do any of these 3 options i am really out of hope that you should do whatever you believe is your job by missing basic understanding signature.asc Description: OpenPGP digital signature
Re: Dumping drupal databases
* Reindl Harald [121031 08:12]: > > > Am 31.10.2012 16:34, schrieb Tim Johnson: > > * Johan De Meersman [121031 07:10]: > > > >> Given the different location of the datafiles and assuming the > >> actual drupal does work, I'm starting to suspect that whatever > >> installer you used created a second instance of mysql. Your drupal > >> configfile should hold the necessary data to connect to it. > > > > You are correct. Running on 3307. (from settings.php) But even > > loging into that instance was not showing me the drupal > > databases - so I was stumped! I would guess that was because the > > 3307 instance was using the system-wide my.cnf instead of the > > drupal my.cnf. I could not see from documentation how to invoke > > mysql or mysqldump with a specific my.cnf. > > See my response to your other email. > > thanks Johan > > you MUST NOT use "localhost" if you want to connect to > a different mysqld-port because "localhost" is unix-socket > > mysql -h 127.0.0.1 --port=3307 -u -p I get "access denied" when I do that. 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 31.10.2012 16:34, schrieb Tim Johnson: > * Johan De Meersman [121031 07:10]: > >> Given the different location of the datafiles and assuming the >> actual drupal does work, I'm starting to suspect that whatever >> installer you used created a second instance of mysql. Your drupal >> configfile should hold the necessary data to connect to it. > > You are correct. Running on 3307. (from settings.php) But even > loging into that instance was not showing me the drupal > databases - so I was stumped! I would guess that was because the > 3307 instance was using the system-wide my.cnf instead of the > drupal my.cnf. I could not see from documentation how to invoke > mysql or mysqldump with a specific my.cnf. > See my response to your other email. > thanks Johan you MUST NOT use "localhost" if you want to connect to a different mysqld-port because "localhost" is unix-socket mysql -h 127.0.0.1 --port=3307 -u -p signature.asc Description: OpenPGP digital signature
Re: Dumping drupal databases
* Johan De Meersman [121031 07:10]: > Tim Johnson wrote: > > >* Ananda Kumar [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. > If I'm right about the second instance, that will cause the files > to be opened by both daemons. Which is rather on the bad side of > things. Sounds like good judgement on your part. As I have already posted to the ML, I was "forced" to use the drupal backup_migrate module. "When in drupal do as the drupals do". cheers -- 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
* Johan De Meersman [121031 07:10]: > Given the different location of the datafiles and assuming the > actual drupal does work, I'm starting to suspect that whatever > installer you used created a second instance of mysql. Your drupal > configfile should hold the necessary data to connect to it. You are correct. Running on 3307. (from settings.php) But even loging into that instance was not showing me the drupal databases - so I was stumped! I would guess that was because the 3307 instance was using the system-wide my.cnf instead of the drupal my.cnf. I could not see from documentation how to invoke mysql or mysqldump with a specific my.cnf. See my response to your other email. thanks Johan -- 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 [121030 10:40]: > OP : > * Tim Johnson [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). 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
Re: Dumping drupal databases
OP : * Tim Johnson [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
* Hassan Schroeder [121030 08:25]: > On Tue, Oct 30, 2012 at 9:12 AM, Tim Johnson 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
* Ananda Kumar [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
* Kishore Vaishnav [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: Dumping drupal databases
why dont u create a softlink On Tue, Oct 30, 2012 at 11:05 PM, Tim Johnson wrote: > * Reindl Harald [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
* Reindl Harald [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
* Shawn Green [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
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
* Tim Johnson [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
Am 30.10.2012 17:34, schrieb Tim Johnson: > * Reindl Harald [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
* Reindl Harald [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:17, schrieb Hassan Schroeder: > On Tue, Oct 30, 2012 at 9:12 AM, Tim Johnson 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
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 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
* 小刀 <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
