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
* 小刀 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
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
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
* 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,
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
* 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
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
* 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:
* 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.
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
* 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.
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
* 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
* 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
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
* 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
17 matches
Mail list logo