[Gllug] Importing data into MySQL

[Tom Schutzer-Weissmann]

--- Mark Preston <mark at markpreston.co.uk> wrote:
[...]
> I only have a 
> rudimentary grasp of MySQL and the commands below
> will restore the 
> details, but at the expense of overwriting any
> existing details held in 
> the database. Ideally I would like to update and
> install new records 
> whilst preserving other existing records on the
> reception computer.

No problem.

molar at toothpix:~$ mysqldump -n -t databasename
tablename ;

will give you a set of INSERT statements that won't
clobber your existing database.

--no-create-db, -n : don't create the database.
--no-create-info, -t : don't create the table.
These come straight from the MySQL manual entry for
mysqldump.


It might be easier for your patients if they could
press a button and have the details submitted over the
web, instead of having to come in with a disk or USB
pen. Maybe I'm just scared of dentists...

Tom

It's a nice way to get your patients' teeth into
linux. Are they biting?
ohohohoho

(Sorry)
(Sorry Sorry)
(usw.)


		
_______________________________
Do you Yahoo!?
Express yourself with Y! Messenger! Free. Download now. 
http://messenger.yahoo.com
-- 
Gllug mailing list  -  Gllug at gllug.org.uk
http://lists.gllug.org.uk/mailman/listinfo/gllug