Re: Moving MySQL database from one machine to another and remotely accessing dbs?
Martin Waller wrote:
Hi,
I'm using MySQL 4.1 on Etch and have a database (that I created) on
another machine (still Sarge) that I want to transfer to the other
before upgrading to etch on that machine also. Where should I look to
find out how to do this? Is it just a matter of locating the database
and copying or is it more subtle? Are there any security considerations?
On the security note, I'd also like to be able to access the database
from other machines but am unable as by default remote access to the
server isn't allowed - again, where should I be looking for information
on how to change this?
The MySQL docs are pretty daunting for a database newby, and I was
hoping there'd be some debian-specific documentation somewhere...
Thanks if anyone can help point me to the relevant information source,
You haven't mentioned it, but are you using phpmyadmin? If so, exports
and imports are fairly painless. I find it easier than the command line,
but I'm using apache and php anyway. It's also handy for hacking back
the mistakes that your access software has added...
From version 4 (sarge) /etc/mysql/my.cnf:
bind-address = <IP address of relevant NIC>
and a restart will get it listening.
Apart from the debian-sys-maint user, there doesn't seem to be much
localisation of mysql. The standard docs should be OK. There really
isn't a whole lot to it, apart from the privilege system. phpmyadmin
really helps there. The worst danger is of permanently locking yourself
out before you've got the hang of it, at which point you reinstall.
Don't commit priceless data to it until you understand the privileges.
Reply to: