# Quick mySQL question

**URL:** <https://forum.kirupa.com/t/quick-mysql-question/42181>\
**Category:** programming\
**Created:** [February 6, 2004, 4:01am UTC](https://forum.kirupa.com/t/quick-mysql-question/42181 "2004-02-06T04:01:02Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [February 6, 2004, 4:01am UTC](https://forum.kirupa.com/t/quick-mysql-question/42181/1 "2004-02-06T04:01:02Z")

</div>

let’s say I have a mySQL database and want to move it over to another webserver, how do I do this?

thanks

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [February 6, 2004, 4:26am UTC](https://forum.kirupa.com/t/quick-mysql-question/42181/2 "2004-02-06T04:26:41Z")

</div>

I believe you just need to copy the contents of the data folder in the mysql folder.

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [February 6, 2004, 7:50am UTC](https://forum.kirupa.com/t/quick-mysql-question/42181/3 "2004-02-06T07:50:28Z")

</div>

If you use PHPMyAdmin, there’s an export feature 🙂

or you could write an app to automate it quickly… or you could do it by hand(last resort)

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [February 6, 2004, 4:25pm UTC](https://forum.kirupa.com/t/quick-mysql-question/42181/4 "2004-02-06T16:25:23Z")

</div>

> \*Originally posted by njs12345 \*  
> \*\*If you use PHPMyAdmin, there’s an export feature 🙂  
> \*\*

🍺

thanks dude, export fearture seems really cool.

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [February 6, 2004, 5:15pm UTC](https://forum.kirupa.com/t/quick-mysql-question/42181/5 "2004-02-06T17:15:49Z")

</div>

I believe however when you do an export from phpMyAfmin, that it only exports the tables and data. If I remember correctly you will have to create an empty database schema before you do them import because you need a place to import to.

So, if you are exporting a database called mydb then run the export on the first machine. Then go to the new machine and create a database called mydb. Then run the import.

Also, I this won;t bring over your users, you will need to export those from the mysql database.

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [February 6, 2004, 6:31pm UTC](https://forum.kirupa.com/t/quick-mysql-question/42181/6 "2004-02-06T18:31:05Z")

</div>

thank you for that info blind