* 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
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
d
* 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
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
>> config
* 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 re
* 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
* 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
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
* 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
* 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 t
* 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
htt
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.
> >
> >
* 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 .
* 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:
> >
> > **
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 re
* 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
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 m
* 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
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 th
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
* 小刀 <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
h
21 matches
Mail list logo
