473,387 Members | 1,541 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

How can i upload my database from local pc to server

Hi everyone.

I got a problem when i tried to upload MYSQL database. I don't have any idea how to upload it. It is my first time to do it. I already upload the pages from my local pc to server with Bulletproof FTP transfer and now I want to upload my database. For now I am using vertrigoServ 2.15 and I found my database in folder path C:\Program Files\VertrigoServ2\Mysql\data\mydatabase. and i want it to transfer to my server.

Do I need to install special software to fix my problem?
Do I need to install MYSQL and php5 to my server?

If there is any one who can give me detailed information, please make it clear and more detail b/se i don't have any idea how to upload database.

Thank you
Ahmed Abdella
Mar 26 '07 #1
3 11631
bartonc
6,596 Expert 4TB
Hi everyone.

I got a problem when i tried to upload MYSQL database. I don't have any idea how to upload it. It is my first time to do it. I already upload the pages from my local pc to server with Bulletproof FTP transfer and now I want to upload my database. For now I am using vertrigoServ 2.15 and I found my database in folder path C:\Program Files\VertrigoServ2\Mysql\data\mydatabase. and i want it to transfer to my server.

Do I need to install special software to fix my problem?
Do I need to install MYSQL and php5 to my server?

If there is any one who can give me detailed information, please make it clear and more detail b/se i don't have any idea how to upload database.

Thank you
Ahmed Abdella
Replication is the key.
Mar 26 '07 #2
ronverdonk
4,258 Expert 4TB
Basically, in order to upload a database to the server, you also must have a MySQL installed at that server. How would you otherwise import the uploaded data?

Uploading itself can be done very quickly, provided you have MySQL installed at your server. At your PC you can export (phpMyAdmin is the easiest way) each database to an SQL format file. Upload that SQL file and import it into the server's MySQL.

Ronald :cool:
Mar 27 '07 #3
Basically, in order to upload a database to the server, you also must have a MySQL installed at that server. How would you otherwise import the uploaded data?

Uploading itself can be done very quickly, provided you have MySQL installed at your server. At your PC you can export (phpMyAdmin is the easiest way) each database to an SQL format file. Upload that SQL file and import it into the server's MySQL.

Ronald :cool:
I have webspace I bought from canaca.com and with the basic package it doesnt come with MySQL.. in my control panel for the site it has a version of MySQL but no disk space and I cant add a database. Is there anyway I can download and install MySQL onto it through FTP? (only way i know to transfer the files)
Mar 30 '07 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

5
by: ree | last post by:
I have a tables for a database that I have entried data in to. I have used the table on my local comp. and used apache & mySql to test it out. Now I need to upload the table to the site. But...
3
by: dave | last post by:
Hello there, I am at my wit's end ! I have used the following script succesfully to upload an image to my web space. But what I really want to be able to do is to update an existing record in a...
4
by: Mattias | last post by:
Hi I am building a simple database system in MS Access 2002 and would like to create a command button that upon clicking transfers the current mdb-file to an ftp-server. Is there a solution for...
1
by: Daniel | last post by:
Hi, can u explain to me what is the path need to use in order to upload and download the file based on below solution: 1.Set up a folder that both the web app and SQL server can get to. 2.Do a...
2
by: Siobhan | last post by:
Hi - I create a input box as follows: <INPUT id="inpJobDescEmpSpec" style="BORDER-RIGHT: gray thin solid; BORDER-TOP: gray thin solid; Z-INDEX: 181; LEFT: 232px; BORDER-LEFT: gray thin solid;...
18
by: Jen | last post by:
I'm using Microsoft's own VB.NET FTP Example: http://support.microsoft.com/default.aspx?scid=kb;en-us;832679 I can get the program to create directories, change directories, etc., but I can't...
6
by: Vic Spainhower | last post by:
Hello, I am trying to do a FTP file upload which works fine on my localhost but on my ISP server it fails. I can't seem to find where I can go to find the specific cause of the failure. In both...
3
by: Stephan | last post by:
Hi all, I am new to access and I face the following "issue": I would like to create a database, to which users can upload files (=pdf, doc, xls...). The files shall be stored locally on a...
1
by: =?Utf-8?B?TGFtaXM=?= | last post by:
HI, I am doing an aspx application and need to let my users be able to edit the information in my database by the page. My first Idea was to let them export the information to an excel file at...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.