Restoration from Tarball

[Adam Smith]

Running vers 5.0.18 on FreeBSD 4.9
Have some old data in tar format. Set of *.frm, *.MYI, *.MYD files - How
can I import these inot the New mysql system

Thanks

[Giuseppe Maxia]

Adam Smith wrote:

> Running vers 5.0.18 on FreeBSD 4.9
> Have some old data in tar format. Set of *.frm, *.MYI, *.MYD files - How
> can I import these inot the New mysql system
>
> Thanks

Follow these steps:
1) find which data directory you are using
mysql> SHOW VARIABLES LIKE "datadir";
2) find out which user and group own the files the files in your data directoty
$ ls -l /path/to/data_directory
(let's say those user and group are "myusr" and "mygrp")
3) make a new directory under your data directory and cd there
$ mkdir /path/to/data_directory/new_db
$ cd /path/to/data_directory/new_db
4) untar the files
tar -xf filename.tar
(Assuming that your tar does not have any subdirectory. if it does, just move the files
in the directory that you created manually, and erase the one coming from the tar file)
5) change the ownership of the new directory to the user and group you found in step (2)
$ cd /path/to/data_directory/
$ chown -R myusr.mygrp new_db
6) From mysql, you can just USE new_db and you should see the tables.

If you get an error, review the above steps carefully.

ciao
gmax

--
_ _ _ _
(_|| | |(_|>< The Data Charmer
_|
[url]http://datacharmer.blogspot.com/[/url]