You are not logged in.
Pages: 1
Hi!
I have archlinux 2009.02 on a PC and there are some boot problems with it (something simillar like in this thread http://bbs.archlinux.org/viewtopic.php?id=75530), so the easiest way seems to be reinstalling arch. I copied all files from the machine with knoppix 6.0.1, but I need to export my mysql database too. How can I do this (mysql is not installed on knoppix)?
Or maybe I can export it with arch live cd?
Thanks in advance,
-skazhy
Offline
I *think* you can just copy the data files from /var/mysql/ if the MySQL process isn't running... Someone else can confirm that I hope.
Are you familiar with our Forum Rules, and How To Ask Questions The Smart Way?
BlueHackers // fscanary // resticctl
Offline
The "correct" way to get your schemas out of a MySQL database is :
mysqldump --user=root --password my_db > my_db.sql
That's is. You then install the new MySQL database somewhre else and you can then upload your schema into it.
R.
Last edited by ralvez (2009-07-13 13:09:46)
Offline
I know with postgresql, you can copy the data directory. But it might create problems if you move it between major version release. MySQL might be the same.
Offline
The "correct" way to get your schemas out of a MySQL database is :
mysqldump --user=root --password my_db > my_db.sql
That's is. You then install the new MySQL database somewhre else and you can then upload your schema into it.
R.
Yes, that is assuming the MySQL server is running. The OP is trying to backup from a LiveCD without a copy of the MySQL binaries.
I know with postgresql, you can copy the data directory. But it might create problems if you move it between major version release. MySQL might be the same.
I'd assume it would be the same, but if you keep the same version, it should be OK. Backup /var/cache/pacman/pkg/mysql* too maybe?
Are you familiar with our Forum Rules, and How To Ask Questions The Smart Way?
BlueHackers // fscanary // resticctl
Offline
Yes, copying the data directory directly should work. Just make sure the proper permissions are set on the data files, or else you'll be getting some ugly errors when you try updating your database.
Education is favorable to liberty. Freedom can exist only in a society of knowledge. Without learning, men are incapable of knowing their rights, and where learning is confined to a few people, liberty can be neither equal nor universal.
Tu ne cede malis sed contra audentior ito
Offline
Pages: 1