This is my first post, so go easy on me
Can anyone offer some good suggestions about how to replicate a mySQL database both locally within the same subnet, and across the net to another server somewhere else? I have read a ton of good stuff about mySQL's built-in replication, but I'm looking for alternatives.
Also, I'm looking for a good mySQL host ... someone who can provide great uptime and possibly replication as a service.
with phpmyadmin you can export the structure and data into a file.
Then you can use this file (contains all required sql statments) to create and fill the tables within a different database.
The file will not contain a statment to create the database itself, only the tables but you can add additional statements to the file with an editor.