[wgrayson]

It just can't be this hard! I have no programming experience, but am taking some pretty good dreamweaver / HTML course that are introducing us to the fundamentals of dynamic websites using Coldfusion and mySQL.

So, I've created some simple mySQL databases (mySQL 5.1). Created the tables in Administrator. Added the data using the query browser (next week we learn other ways to add data to tables ). I'm doing all of this on my laptop that I take to class. I'd like to transfer this work to my home desktop. Transferring the actual site (.cfm & html) pages is no hassle -- just copy the files to the corresponding directory from my laptop to my desktop. But I can't figure out how to transfer the actual database table data. Not the schemas or tables. But the data. I've been googling the subject, and keep coming up with answers about "generating scripts" or using something called a "mySQLdump", but I don't have the working knowledge to understand the instructions.

People must do this all the time if they are moving from one host to the next. Any simplified help would be appreciated. Oh yeah, system specs:

Laptop is running Win7 home premium, that stores schemas (?) under Users/Program Data. I will be transferring files to an XP machine (XP has a different place that stores this information). I'm currently using Coldfusion 8 developer edition to interact with dreamweaver. I am running all sites on a "local" server, and not uploading the files. I'm using Adobe dreamweaver CS3 to create sites. Coldfusion, Dreamweaver, and mySQL 5.1 are loaded on both machines in the same directories.

Oh yeah. Windows 7 doesn't play nicely with XP for file sharing (I finally gave up on that one). Only works one way. Win7 can see and edit files on XP machine, but XP cannot do the same unless files are in the "public" directory on the Win7 machine.

Any help would be appreciated. Even explaining to a BONEHEAD LIKE ME how to execute the mySQLdump procedure. I guess I have to take programming next semester.

Thanks in advance,
W!

[MMJ]

Look around for an export option in your query browser or download mysqlAdmin (if that isn't what you have).

[Lordandmaker]

You want mysqldump. It'll dump the contents of the db into a file which is basically the list of SQL commands needed to recreate it.

http://lmgtfy.com/?q=mysql+dump

[MMJ]

Major misuse of lmgtfy, he already googled and even googled for that.

[wgrayson]

I'm not sure, but I think the simplest solution was to BACKUP the schema mySQLadmin, then RESTORE IT IN THE ORIGINAL LOCATION using mySQL on the new destination drive. Now, I'm only working "locally" on two computers. I don't know if this can be done to transfer from one host to another. But so far, this method is working.

If I ever have to upload this to a host, let's see if this works.

[Lordandmaker]

Originally Posted by MMJ

Major misuse of lmgtfy, he already googled and even googled for that.

Yeah, I saw. But since he didn't bother to say what he had issues with in the search results (have you looked at them? They're pretty step-by-step) I thought I'd point him at it again in the hope he'd come back with a useful question.

Saying "I googled it and some of it worked and I didn't understand some of the rest" is approximately useless from the point of view of someone trying to help.

So, yeah, he managed the typing into google bit, and the hitting 'search', but failed at the rest of the googling bit.

Originally Posted by wgrayson

I'm not sure, but I think the simplest solution was to BACKUP the schema mySQLadmin, then RESTORE IT IN THE ORIGINAL LOCATION using mySQL on the new destination drive. Now, I'm only working "locally" on two computers. I don't know if this can be done to transfer from one host to another. But so far, this method is working.

Yeah, that's pretty much it.
Backup off one host, restore onto another. How were you expecting it to work?

[wgrayson]

If you ever see my username again show up on this forum, don't take the time to respond to any question I post.

As a novice user, the concept of working with databases pretty difficult. If you don't have the patience with novice questions, THEN DON'T WASTE YOUR TIME OR MINE TO ANSWER THEM. Or have you just spent so much time coding and gaming that accepted conventions of interaction with individuals has escaped you?

Go flame somebody else and grow up.

[Lordandmaker]

Originally Posted by wgrayson

If you ever see my username again show up on this forum, don't take the time to respond to any question I post.

Noted.

As a novice user, the concept of working with databases pretty difficult.

I know. Databases are not simple.

If you don't have the patience with novice questions, THEN DON'T WASTE YOUR TIME OR MINE TO ANSWER THEM.

I do have the patience for novice questions. I spend an inordinate amount of my spare time answering novice questions (I'm certainly in no position to answer any other sort), and it's not common for me to get responses like this.

I am used to doing so on forums and lists where it is expected that those asking the questions will put as much effort into the question as they want people to put in to finding an answer. My only qualm with anything you've done is that you were incredibly vague as to the problems you were having, and spent several paragraphs more than I felt neccesary to get to the question you were asking.
If you'd said "I've been following this tutorial, but I don't understand pt4" then I or someone else would have explained pt4. The fact that you've done a search and apparently understood nothing of it gives anyone trying to help you very little to go on - I don't now where to start.

ESR's got a fantastic text on how to ask questions with the greatest chance of getting a satisfactory answer, and I'd _really_ suggest reading it and abiding by it to get useful information out of forums and the like.
It is incredibly easy to ask a crap question, and nobody wants to do that. It's not a lot more difficult to ask a good one and get some good answers.

Go flame somebody else and grow up.

I've flamed nobody. Please, don't infer any personal antagonism from my posts, there isn't meant to be any.

In case it's a bit of what you were getting at, my "how were you expecting it to work" was a genuine question - what were you expecting?

[MMJ]

I lol'd.

Someone taking the internet a little too seriously it seems.

Protip: get off your high horse, no one cares about your self righteousness.

[jlhaslip]

Does your Server stack include phpmyadmin? It can export the Database and then simply Import it into the other machine using phpmyadmin again, assuming it is installed on both machines. Create the sql file on one machine and then email it to your self and receive it on the second machine. Might want to zip it first if it is a large DB.

XAmpp includes phpmyadmin in its package. Might want to have a look at that as an option.