How Do I Upload Sql Database - Webmasters - Nairaland
Nairaland Forum / Science/Technology / Webmasters / How Do I Upload Sql Database (916 Views)
How Can I Upload More Than One File At Once Into My Cpanel? / How Do I Upload A Video On Nairaland / How Can I Upload My Site That I Created With Joomla To Internet (2) (3) (4)
| How Do I Upload Sql Database by phantomcat(m): 9:12am On Sep 28, 2007 |
Guys i need help on this issue, I'm new to databases, i developed a site using asp and access database and i want to migrate to SQL. On my local machine i have exported the database to SQL and tested it, the question is how do i move the SQL database to the hosting server? How do i locate the script to upload in SQL? |
| Re: How Do I Upload Sql Database by webmaster3: 10:49am On Sep 28, 2007 |
well if your using mysql, you have to run mysqldump. This will compres your database into a text file, then log on to phpbb on your server and import database. syntax for mysqldump mysqldump -u root -p dbname>textfilename dbname stands for ure database name textfilename stands for the name you want to call your textfile. Please note the textfile will be dumped in your mysql/bin folder. You can research on mysqldump. Hope this helps |
| Re: How Do I Upload Sql Database by webemerald(m): 12:21pm On Sep 28, 2007 |
Web mater, he runs asp not php so ur advice doesnt help, phanxx why dont u google for answers |
| Re: How Do I Upload Sql Database by tundewoods(m): 1:03pm On Sep 28, 2007 |
If your remote hosting server is running on apache,then their is a high possiblity that it will be using CPANEL. 1. When you log in to your CPANEL, at the bottom of the page you will see a mysql icon or link,click on this mysql icon link. 2. At the tale bottom of the mysql page,click on link with phpmyadmin on it. 3. In the PHPMYADMIN page,click on SQL link,this will prompt a popup window. 4. In the SQL popup,there is a textarea that you can copy your sql code from the file and paste in the text area. and click on a go button at the end to run the sql query. Lets see how it goes. |
| Re: How Do I Upload Sql Database by Afam(m): 3:09pm On Sep 28, 2007 |
SQL is not MySQL. It seems the guy is on pure Windows platform so may not be doing anything with MySQL considering the fact he is even moving from Access. |
| Re: How Do I Upload Sql Database by Kobojunkie: 3:19pm On Sep 28, 2007 |
Two Options. 1) Right click the Database and then use the script option to copy the database to the Server, the tables, the stored procedures, everything and then you can back up any data you have on there, move it to the server and try a restore on the copy Database and see if that works 2) Use SQL's Copy Wizard to copy the database to the server if you are using Enterprise version KoboJunkie |
| Re: How Do I Upload Sql Database by smartsoft(m): 5:00pm On Sep 28, 2007 |
nah wah oo simple english sorry oo na hard knocks, the guy only runs on SQL not MySQL you guys too like open source hey guy see just look for the Path on wwwroot folder on your Windows panel and you will be able to connect and upload hey buzz me Yahoo Messenger "smartsoftngr": i can help you out |
| Re: How Do I Upload Sql Database by Kobojunkie: 5:06pm On Sep 28, 2007 |
The information I gave him there is for MS SQL , which is what I use. Works well if you log in remotely to your server using windows remote too. I mean since you built the DB on your local machine, you can log in using windows remote and then copy over the scripts or the backup or even copy the version on the local machine to the remote machine http://support.microsoft.com/kb/314546 Kobojunkie |
(1) (Reply)
I Need To Login On Date Sites And Change My Ip / How Do You Know A Good Webmaster ? I Need Help Pls! / Help With Free Asp Hosting
(Go Up)
| Sections: politics (1) business autos (1) jobs (1) career education (1) romance computers phones travel sports fashion health religion celebs tv-movies music-radio literature webmasters programming techmarket Links: (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) Nairaland - Copyright © 2005 - 2024 Oluwaseun Osewa. All rights reserved. See How To Advertise. 18 |