Tycoon Talk
Become a Big fish!
The number 1 forum for online business!
Post topics, ask questions, share your knowledge.
Tycoon Talk is part of Freelancer.com - find skilled workers online at a fraction of the cost.

The Database Forum


You are currently viewing our The Database Forum as a guest. Please register to participate.
Login



Reply
Newbie question. sql file and....
Old 06-26-2006, 03:29 PM Newbie question. sql file and....
Average Talker

Posts: 27
Location: Holland Amsterdam
Trades: 0
Hi who can please explain me how to create my sql file for my database, which program should i use? and and what information should i put there? , in which folder do i have to save it when done, if in the same folder where my website is? or somewhere else?

and last but not least when looking inside my phpmyadmin i discover the option to upload the sql file is missing or am i wrong?

here a link to an screenshot of my phpmyadmin

http://i30.photobucket.com/albums/c3...ot-myadmin.png


and here the link to the tutorial i am using to do this work where the option to upload the sql file is to see,

http://www.dayanahost.com/tutorials/...in_phpMyAdmin/

Last edited by latintrans; 06-26-2006 at 03:31 PM..
latintrans is offline
Reply With Quote
View Public Profile
 
 
Register now for full access!
Old 06-26-2006, 05:17 PM Re: Newbie question. sql file and....
Defies a Status

Posts: 1,605
Trades: 0
The export button will export a complete backup of your DB and data.

This will be saved on your local computer in the directory you choose when prompted.

You should be able to use the file on you local computer to restore your DB or recreate it on a different server by using the import function after you have created a new DB.

My experience with this is somewhat linmited
__________________
Colbyt

Please login or register to view this content. Registration is FREE
colbyt is offline
Reply With Quote
View Public Profile
 
Old 06-27-2006, 11:00 AM Re: Newbie question. sql file and....
mgraphic's Avatar
Truth Seeker

Latest Blog Post:
JAMISONTUNES
Posts: 2,898
Name: Keith Marshall
Location: Connecticut
Trades: 0
You should be able to upload your sql file via the Import tab.
__________________

<mgraphic /> - I don't have a solution but I admire the problem.
mgraphic is offline
Reply With Quote
View Public Profile
 
Old 06-28-2006, 06:38 AM Re: Newbie question. sql file and....
ibbo's Avatar
Super Spam Talker

Posts: 880
Location: Leeds UK
Trades: 0
You can also click on the SQL tab and paste it in.

Thats when your SQL file is ready though.
Have you some idea of what your database will do and have you thought out your tables and what have to store inside it.

Let us know

Ibbo
__________________

Please login or register to view this content. Registration is FREE

Please login or register to view this content. Registration is FREE

Please login or register to view this content. Registration is FREE

Please login or register to view this content. Registration is FREE

Linux user #349545 :
(GNU/Linux)iD8DBQBAzWjX+MZAIjBWXGURAmflAKCntuBbuKCWenpm XoA7LNydllVQOwCf
ibbo is offline
Reply With Quote
View Public Profile Visit ibbo's homepage!
 
Old 06-28-2006, 12:12 PM Re: Newbie question. sql file and....
Extreme Talker

Posts: 170
Name: XpIndia.Com
Trades: 0
Quote:
Originally Posted by latintrans
Hi who can please explain me how to create my sql file for my database, which program should i use? and and what information should i put there? , in which folder do i have to save it when done, if in the same folder where my website is? or somewhere else?

and last but not least when looking inside my phpmyadmin i discover the option to upload the sql file is missing or am i wrong?

here a link to an screenshot of my phpmyadmin

http://i30.photobucket.com/albums/c3...ot-myadmin.png


and here the link to the tutorial i am using to do this work where the option to upload the sql file is to see,

http://www.dayanahost.com/tutorials/...in_phpMyAdmin/
Hi friend

Just wonderig your problem has been solved or not. I have a small script which can zip ur sql and email it to your email id or send it to a remote ftp server .


Need it ??!!!
__________________

Please login or register to view this content. Registration is FREE

Server alert/reseller-
Please login or register to view this content. Registration is FREE
XpIndia.Com is offline
Reply With Quote
View Public Profile
 
Reply     « Reply to Newbie question. sql file and....
 

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off





   
RSS Feed  Feeds: RSS   JS   XML
RSS Feed  Feeds for this forum: RSS   JS   XML



Page generated in 0.34834 seconds with 12 queries