Ok couple questions here. I have a dedicated server that I got to host my website the server has directAdmin set up on it. Its running fedora core 2
Ok now I have a couple dbs direct admin will backup all the dbs for a particular user and does not provide any options to only restore one particluar db that the user may have. So I look instead to phpMyAdmin which allows you to backup only one of the users db but forces you to download it to your computer and upload the db again to resore it (which is much to big for me to do this)
Question how can I backup and restore one db not all of them. And in phpMyAdmin can i export to a local path i.e. /home/user/backups and restore from there rather then downloading it to my computer and having ot upload it running into timeouts and exceeded 2MB limits.
Ill take the cmd line solutions as well but seems like there would be a way to do this for people without SSH ability.
Thanks
Nutz
Ok now I have a couple dbs direct admin will backup all the dbs for a particular user and does not provide any options to only restore one particluar db that the user may have. So I look instead to phpMyAdmin which allows you to backup only one of the users db but forces you to download it to your computer and upload the db again to resore it (which is much to big for me to do this)
Question how can I backup and restore one db not all of them. And in phpMyAdmin can i export to a local path i.e. /home/user/backups and restore from there rather then downloading it to my computer and having ot upload it running into timeouts and exceeded 2MB limits.
Ill take the cmd line solutions as well but seems like there would be a way to do this for people without SSH ability.
Thanks
Nutz