On 2005-11-06, Todd Cary [EMAIL PROTECTED] wrote:
system(mysql -u user -p db /tmp/mydb);
With the -p switch, the user is asked for the password. How does that
happen with the system command?
Don't leave a space between -p and the password
mysql -u user -pyourpassword -h somehost db
Hello,
apologies if I am OT.
I would like to know if anybody has developed a mysql+php BibTeX
bibliography management systems/web interface.
I have just seen
http://www.rennes.supelec.fr/ren/perso/etotel/PhpBibtexDbMng/, and would
like to know whether there is anything else.
If you know any
Robert -
I installed phpmyadmin on the shared server, however I am not sure of
the command to run the sql file, mybackup.sql, that was created on the
dedicated server with mysqldump.
The docs as best as I can read them indicate that all I need to type
into the Run SQL query text box is the
Robert -
I used the backup file on my desktop computer and the browse button.
After the upload was over, I got this message:
Your SQL query has been executed successfully:
The content of your file has been inserted. (sfyc_data_20051105.sql:
1 Instructions)
However the tables were not
Yes, this is an upload of a local file. I'm not sure if there is a way to
run the sql command inside the file if it's sitting on the server. Keep in
mind that you may run into size upload restrictions (i.e. files larger than
2 megs, or whatever your webhost has set it to). If that's the case,
Do you have permission to create tables (I would assume so)? Can you run
any successful queries (i.e. not using the file upload)? If so, you might
need to check your configuration file, or you might have some file size
limitations, as I mentioned in my previous email.
-Original Message-
Robert -
I created and loaded the tables by brute force. That is, I took each of
the CREATE TABLE statements from the mysqldump file and executed them in
the phpmyadmin SQL query area and then did the same for the INSERT commands.
Not what I am use too with a dedicated server though :-) !!