473,662 Members | 2,382 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

How can i upload my database from local pc to server

1 New Member
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\VertrigoS erv2\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 11671
bartonc
6,596 Recognized Expert Expert
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\VertrigoS erv2\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 Recognized Expert Specialist
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
Blughblue
1 New Member
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
3758
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 not sure how to do it. I don't want to enter the details all again. Can someone point me to a link that explains how to upload these tables. Also the the webhost is using Cpanel.
3
11753
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 table in MySQL with the path & filename to the image. I have successfully uploaded and performed an update query on the database, but the problem I have is I cannot retain the primary key field in a variable which is then used in a SQL update...
4
9335
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 this in MS Access 2002 or do you have any other suggestions to solve this issue? // Mattias
1
2225
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 simple file upload from the web app what is DTS package and how to apply it? 3.Set up a DTS package to periodically check the folder to do an import. Your help will be appreciated.
2
1513
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; WIDTH: 640px; BORDER-BOTTOM: gray thin solid; POSITION: absolute; TOP: 400px; HEIGHT: 22px" tabIndex="27" type="file" maxLength="250" size="87" name="inpJobDescEmpSpec" RunAt="Server"> to allow the user to select a file which I want saved to a SQL...
18
4335
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 get it to upload a file to the FTP server. I just get a "Cannot connect to remote server" error after this TRY: s = New Socket(AddressFamily.InterNetwork, SocketType.Stream, ProtocolType.Tcp)
6
3035
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 cases the file is being transmitted to the same FTP server and using the same PHP script so it shouldn't be a file size or login credentials problem. Could someone please help me out and give me some ideas what is wrong. I would really...
3
22284
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 server. The database needs to be accessed via Access form (no html, asp,...) as we don't have an internal web server running. I would like to create a form that allows the user to browse his local harddrive, select the file and upload it directly...
1
2846
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 local machine where they can edit it och then upload the file by the page again to save down their changes down to the database. Now, this is the code I am using to Upload from sql to excel : HttpResponse response = HttpContext.Current.Response;
0
8432
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8762
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
8633
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
7365
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
5653
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4179
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4347
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2762
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
1992
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.