Jump to content



Photo

How Do I Copy A Mysql File To The Server


  • Please log in to reply
3 replies to this topic

#1 Peter77

Peter77

    Newbie

  • Members
  • Pip
  • 3 posts

Posted 29 August 2011 - 12:29 PM

Please bear with me - I'm a MySQL dummy - aka beginner. I have a couple tables on my local machine. I have MySQL 5.5 also installed as a server on the remote server. Do I just copy the files - is that it? On my local machine (XP) they are located at:

C:\Documents and Settings\All Users\Application Data\MySQL\MySQL Server 5.5\data

On the server I have:

C:\ProgramData\MySQL\MySQL Server 5.5\data

Do I just copy the project folder or do I have to perform some sort of install or instantiation?
  • 0

#2 Larry

Larry

    Administrator/Writer

  • Administrators
  • 3,785 posts
  • LocationState College, PA (USA)

Posted 29 August 2011 - 1:23 PM

That *might* work, but what you really should do is use an export and import utility. MySQL comes with command-line versions, but I normally recommend using phpMyAdmin instead.
  • 0

#3 Jonathon

Jonathon

    Advanced Member

  • Members
  • PipPipPip
  • 1,020 posts

Posted 29 August 2011 - 1:23 PM

You can actually just export the file. If you go to the PHPMyAdmin and view the database you want to copy, there should be an export tab, click it and save the file to your desktop, then you can just copy all the SQL commands into the other hosts PHPMyAdmin under the SQL tab and dump all the data in like that. That's what I do.
  • 0

#4 Peter77

Peter77

    Newbie

  • Members
  • Pip
  • 3 posts

Posted 31 August 2011 - 2:21 PM

Thanks very much gentlemen! I'll download PHPMyAdmin right now.
  • 0