transfer mysql databases

[ultimategp1]

Hi does anyone know how to transfer mysql databases from webmin to directadmin? let me know asap thanks!

 

[floyd]

Easiest way is to use command line. Next easiest way is to use phpmyadmin.

 

[nobaloney]

floyd, if ultimategp1 is trying to change the databases to work with DirectAdmin users and be counted in space used by DirectAdmin users, the answers are a bit more complex, as DirectAdmin uses specific naming covention.

ultimategp1, would you please be so kind as to expand on your question if we need to help you further.

Thanks.

Jeff

 

[floyd]

If the username_databasename naming convention was not previously used then a symlink can be created

ln -s databasename username_databasename

It will show up in DA but the number of users will be -1

I am not sure how/if DA will count the space used by the database.

Hi does anyone know how to transfer mysql databases from webmin to directadmin?

Technically you don't. I think you are asking how to transfer databases from server to another. Mysql is the same whether its running Webmin or DA.

If all you want to do is transfer the databases so that your databases will work with whatever scripts you have onto a new server then see my first post. If you want DA to be able to see the databases then see this post.

And just so you know I have not tested if DA will backup symlinked databases. There may be some more things to think about. But the above will ensure that the databases work and can be see in the DA screen.

I have tested the symlinks and DA does see them as databases and scripts do work with them.

 

[ultimategp1]

ok thanks, i will try this out

btw on webmin my databases are named like sbvideo and cake_username etc... and on directadmin databases usually have to appear like username_database name

so will this still work?

i will try it out tho and post back

thanks!