Wrox Programmer Forums
Go Back   Wrox Programmer Forums > PHP/MySQL > MySQL
| Search | Today's Posts | Mark Forums Read
MySQL General discussion about the MySQL database.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the MySQL section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old April 12th, 2005, 05:27 AM
Authorized User
 
Join Date: Feb 2005
Location: , , United Kingdom.
Posts: 16
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to umair_rathore
Default how to upload a mysql db on web server

hi friends!
       I developed a web on my computer using php/mysql. now i wana upload it. i regd a domain supporting php/mysql. i want to upload it from my computer to the server.

       Wot part of the mysql database should i transfer to the web server. My db name is "ppit", and is working well on localhost.


Regards
Umair

__________________
Don\'t express ur emotions, let the Emotions express themselves
 
Old April 12th, 2005, 11:32 AM
Friend of Wrox
Points: 1,515, Level: 15
Points: 1,515, Level: 15 Points: 1,515, Level: 15 Points: 1,515, Level: 15
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Dec 2003
Location: Oxford, , United Kingdom.
Posts: 488
Thanks: 0
Thanked 3 Times in 3 Posts
Default

Umair, use the mysqldump tool (http://dev.mysql.com/doc/mysql/en/mysqldump.html ) to dump your tables into a text file. Then use this text file to repopulate your database, either via a web based interface (cut and paste commands from file into SQL window), or your mysql client...

HTH


--
Don't Stand on your head - you'll get footprints in your hair
                                           http://charlieharvey.org.uk
                                              http://charlieharvey.com
 
Old May 14th, 2005, 05:46 AM
Registered User
 
Join Date: May 2005
Location: , , .
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

umair...Talk about getting ahead of myself but I bought a program called SQLyog on the net for around $99 for doing just that.

There is a Sync tool that logs onto your hosting space and moves everything over.

Of course I put the cart before the horse and bought that in anticipation of setting MYSQL etc up on my PC.

I cannot even get a connection to my database and am posting the problem elsewhere.

Check http://www.webyog.com/sqlyog/index.php for details.







Similar Threads
Thread Thread Starter Forum Replies Last Post
image upload to a mysql database kevo PHP How-To 3 July 21st, 2007 09:13 AM
free web hosting for Classic ASP and a MySQL DB crmpicco Classic ASP Basics 1 March 14th, 2007 06:00 AM
web stats using db. Cause server strain? SoC SQL Server ASP 1 September 27th, 2005 06:20 AM
connecting web server and remote db server via asp moreyt Classic ASP Databases 0 May 31st, 2005 12:13 AM
Upload a Text file from a Web Client to SQL Server petercyriljones Classic ASP Professional 0 May 20th, 2005 10:26 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.