Jump to content


Photo

How to upload a mySql Database to a Web Server


  • Please log in to reply
4 replies to this topic

#1 jeva39

jeva39
  • Members
  • PipPip
  • Member
  • 14 posts

Posted 08 September 2006 - 10:58 PM

Is the first time I work with mySql and I create a DB for testing. I need to upload this DB from my computer to the server (1hostPlan) but I don't know where is located the Database file or what is the file that I need to upload.

I install mySql in C:\mySql

Thanks!!

#2 ToonMariner

ToonMariner
  • Members
  • PipPipPip
  • Advanced Member
  • 3,342 posts
  • LocationNewcastle upon Tyne, UK

Posted 08 September 2006 - 11:15 PM

if you have phpmyadmin on your machine use the EXPORT button located in the menu across teh top of teh screen. This will create a .sql file.

Then goto phpmyadmin on your server and there will either be an IMPORT link (again at the top). Or on teh SQL link there will be a section at the bottom of teh from with somethink like import freom file - hit browse, locate file and hit GO.
follow me on twitter @PHPsycho

#3 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 09 September 2006 - 03:48 AM

Assuming your version didn't change much, you could also just dump the files, if you access to the box.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.

#4 jeva39

jeva39
  • Members
  • PipPip
  • Member
  • 14 posts

Posted 09 September 2006 - 04:05 AM

I have problem with phpMyAdmin. I install phpMyAdmin and configure with this config.inc.php file:


<?php 
$i=0; 
$i++; 
$cfg['PmaAbsoluteUri'] = 'http://localhost/phpMyAdmin'; 
$cfg['Servers'][$i]['host'] = 'localhost'; 
$cfg['Servers'][$i]['auth_type'] = 'http'; 
$cfg['Servers'][$i]['user']          = 'root'; 
$cfg['Servers'][$i]['password']      = 'mypassword'; 
?>


When I try to use, appears the Connect to localhost window but don't accept User/Password and never permit access the app. What is wrong?

Finally, In fact I have created the database.sql. I did with the command line of mySql. It is the this file that I must to upload?. If phpMyAdmin does not work for me, how I can to send the file to my server?

Thanks for your time...



#5 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 09 September 2006 - 03:53 PM

I can't help with PHPMyAdmin, but if you have command-line access, you have simply execute the .sql file directly.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users