Printer Friendly Version
Email this thread to a friend
|
Featured Web Site Template |
|
Reflects user activity within the last 5 minutes
|
|
| Member |
Message |
izone123
Joined: Nov 12, 2001
# Posts: 60
|
Posted: 03/25/2002 06:24 am
Isn't there a way that i prepare my MySQL database and various table containing all data to the server directly instead of preparing it on the server with phpadmin?
It will take a lot of internet connection time. PLease Help.
|
 |
NEntropy
Joined: Dec 08, 1999
# Posts: 1117
|
Posted: 03/25/2002 02:13 pm
I don't know exactly what phpadmin is, or what you mean by prepare the database... But if you already have a list of SQL statements designed to setup your MySQL database, you can easily save all of them into one file, upload it to the server, then run it directly from the server, which does save a lot of time over actually doing everything by hand.Can you give some specifics that you are trying to do? Are you inputting each data by hand?
|
|
izone123
Joined: Nov 12, 2001
# Posts: 60
|
Posted: 03/25/2002 06:13 pm
By preparing the database i mean ,creating all the tables,fields,etc. I know this can be accomplished by an SQL file. But it is about the data which is to be entered in the tables.Recently i downloaded a program called Premium Soft MySQL Studio(can be found on
www.mysqlstudio.com . It works just like Microsoft Access and makes the work of creating tables and entering data very easy. There is no need to write each SQL line by hand For ex. i have description of about 100 scientists and i have entered it in a table through MySQL studio. Now if i were to make an SQL file of it. It would be a very tedious and time taking job (as i know about SQL). I just want to upload the prepared tables to the server and get the job done.
|
|
loy
Joined: Jan 28, 2001
# Posts: 286
|
Posted: 03/25/2002 06:56 pm
phpMyAdmin will allow you to create SQL tables using the basic SQL statements, and upload data into your tables in Excel, CSV or basic text formats. It's downloadable for free ... you can get it at almost any php download site and it's very easy to configure.
|
|
NEntropy
Joined: Dec 08, 1999
# Posts: 1117
|
Posted: 03/26/2002 05:10 am
I know that phpMySQL has it, and your mySQL client probably also has it as well... Look for "Save To File" or "Export" feature that allows you to save the database as a single SQL file.If such option exists, it'll probably save you a bundle of time. I'd play with MySQL Studio a little if I had time, but I'm going into Finals week. 
|
|
Sinoed
Moderator
Joined: Dec 11, 2000
# Posts: 5266
|
Posted: 03/26/2002 06:54 am
Nen, phpmyadmin is a browser interface for buiding mySql databases. It comes with quite a few popular distributions. Izone, try this thread:
http://www.phpbuilder.com/forum/read.php3?num=5&id=3624&loc=0&thread=3624
|
|
NEntropy
Joined: Dec 08, 1999
# Posts: 1117
|
Posted: 03/26/2002 07:25 am
Sinoed, the export feature does exist in phpMyAdmin... it's just not stated as such.If you are using phpMyAdmin, to export the data, go to the database you want to export, then go to section called "View dump (schema) of database". Make sure that the Structure and Data radio button is selected, "Send" is ticked off, then click on the "Go" button. You will be able to save the file to a harddrive.
|
|
Sinoed
Moderator
Joined: Dec 11, 2000
# Posts: 5266
|
Posted: 03/26/2002 09:44 am
huh..? Nen, I'm not following your latest post..
|
|
izone123
Joined: Nov 12, 2001
# Posts: 60
|
Posted: 03/26/2002 08:19 pm
Got it ! I wonder i haven't discovered it earlier  . Thanks for the help
|
|
NEntropy
Joined: Dec 08, 1999
# Posts: 1117
|
Posted: 03/27/2002 11:24 am
Sinoed: I thought you didn't know about the export feature of phpMyAdmin, so I was clarifying it... Hmm, I don't know where I got that impression from now that I read the post again, though.izone123: So what was the solution? Were you able to just export the database, then repopulate it again at the server? or was there something else involved? [Note: This message has been edited by NEntropy]
|
|
Sinoed
Moderator
Joined: Dec 11, 2000
# Posts: 5266
|
Posted: 03/27/2002 07:04 pm
lol.. ok, it wasn't just me then.  So how did you do it izone?
|
|
littlejimmy
Joined: Feb 26, 2004
# Posts: 5
|
Posted: 02/26/2004 10:31 am
I have a similar question I think ! I have, at last just prior to reading this thread, found out how to download and save to my hard drive, but the big question is how do I upload the thing to a database that I will be setting up with a new host ?
To clarify, I am moving hosts, and will have to FTP all my sites from where they are at the moment to where they will be in the near future.
Some of the sites are mysql database driven, and I did not personally install the database part myself in all cases.
As stated above, I know how to download the database and save it locally, but then what  ???
|
|
littlejimmy
Joined: Feb 26, 2004
# Posts: 5
|
Posted: 02/26/2004 10:37 am
"As stated above, I know how to download the database and save it locally, but then what ???"
By that I mean how do I get the thing uploaded onto the database set up with the new hosting account ?
|
|
NEntropy
Joined: Dec 08, 1999
# Posts: 1117
|
Posted: 03/02/2004 01:04 pm
What kind of database interface do you have with your hosting company? If you have a package like phpMyAdmin, there should be an option to export your database in complete SQL format. You can then run this file or upload it to recreate the database as well as the content.
|
|
littlejimmy
Joined: Feb 26, 2004
# Posts: 5
|
Posted: 03/02/2004 05:06 pm
On phpMyAdmin I have found the download feature on my present hosted databases which I have worked out how to use, but what it does not do is to provide an upload option !!! That means when I change hosts,and I believe they provide phpMyAdmin as well, I will not have a way to upload the database file which I had previously downloaded from the original database and host, apart from running complex commands from some prompt line using, I think TELNET.
The problem is that mysql appears to be written using 99% "Gobbledeygook" instead of normal English, and the so called help documents are simply incomprehensible unless one is a professional programmer, and lets face it not so many webmasters are actually professional programmers these days.
|
|
NEntropy
Joined: Dec 08, 1999
# Posts: 1117
|
Posted: 03/11/2004 01:05 pm
Hmm, as far as I know, phpMyAdmin does have an upload functionality. You may have to search around a bit for it, though. If that doesn't work out, you can always open the SQL file and copy the text within it and run the commands manually through phpMyAdmin.
|
|
ishak_wahyudi
Joined: Oct 20, 2004
# Posts: 1
|
Posted: 10/21/2004 12:50 am
Simply put your sql command (or called dump) into text file such as sqldump.txt, open and execute on the phpmyadmin.
|
|
mizanbdit
Joined: May 14, 2005
# Posts: 1
|
Posted: 05/27/2005 09:02 pm
How to set a Hit Counter by PHP, please help me with coding.
|
|
You are not permitted to post messages in this forum or topic, because of one or more of the following reasons:
- You have not yet logged in, or registered properly as a member
- You are a member, but no longer have posting rights.
- This is a private forum, for which you do not have permissions.
If you are a recent member, it's possible that you simply have not yet confirmed your account. Please
check your email for a message entitled 'JimWorld Forums: Confirm Your Account' and follow the instructions
contained within.
If you cannot find this message, click here to Re-Send it.
|
If you are still experiencing problem, please read the
Login Assistance
Article for some advice on what may be causing your login not to work properly.
|
Switch to Advanced Editor and ...
Create a New Topic
or Reply to this Thread
|
|
