Moving DB
Moderator: General Moderators
Re: Moving DB
You should crate a .sql script. It's the easiest way. Of coures, if there is no data in that database.soundbwoy wrote:I am moving my database from my development machine to my server. What is the easyiest way to do this. Can I create a .sql script to build it for me?
- twigletmac
- Her Royal Site Adminness
- Posts: 5371
- Joined: Tue Apr 23, 2002 2:21 am
- Location: Essex, UK
phpMyAdmin can making exporting and importing databases a fairly simple operation (assuming of course that you're using MySQL which of course you may not be so sorry if you aren't):
http://www.phpmyadmin.net
Mac
http://www.phpmyadmin.net
Mac
phpMyAdmin will output a text file that is essentially a bunch of SQL commands that will drop and recreate your tables (depending on your options). Then you can use phpMyAdmin on the other side to read the file and run the SQL commands. It all works very nicely, and I use it all the time to take "snapshots" of my web server to import locally for testing.
I do believe the outputted file is in a proper format where you can also run it via a MySQL command prompt, if that is the way you prefer to go.
I do believe the outputted file is in a proper format where you can also run it via a MySQL command prompt, if that is the way you prefer to go.