I have a very large table (over 2 billion rows) which is partitioned by
day. I'd like to archive all the data in the oldest partition to another
table before I drop that partition. Is there some way other than a
simple select statement that has parameters that match those of the
partition whic will
Copy database directory in another location (ex. /db/data). This path must
contains
your databases directories...
/db
--- /data
--- /mysql
--- data file...
--- data file...
--- data file...
--- data file...
--- /test
--- /YourDB1
---
hi,
i am using linux redhat 8 to power mysql. i installed mysql version 4.0.13
using rpm package. by default, the data file of mysql is alocated at
/var/lib/mysql, but i have a limited of diskspace of /var dir (it is about
1G), so, it was easily full loaded with data. now, i want to archive the
da
