Re: Creating Mysql DB with PHP



> >>
> >> Are you copying an existing database (since you mention a SQL dump)?
> >
> >
> > I am Copying an existing database, which the sql dump is created from.
>
> If the original database is MySQL, then all you need to do is copy the
> files.

The original is MySQL


>
> But from the rest, I gather this may not be practical.
>
> >> And have you looked into importing the dump into PHPMyAdmin?
> >
> > I want to package the creation of the database into an install.php So
that
> > the relevant fields can be input
> > DB name
> > Server Name
> > Password etc...
> >
> > so that there is no need to use phpmyadmin.
> >
> > I am trying to avoid phpmyadmin and keep the creation of the database as
> > simple as possible for the user.
>
> I'm guessing from this that it's not necessarily a one-time script, then?

Its not a onetime script as I hope to package all the files together and
distibute.


>
> I wrote a script that does this a few months ago - I'll see if I still
have
> a copy of it.
>
> One possible problem, though - how big is the database (how many rows)?

The database is at the moment 39 tables and the table with the maximum
number of records would contain about 250 records which is 12KB.

Total database size at the moment is under 300KB


.



Relevant Pages

  • Re: MySQL Database problem (probably already solved in a message, but this is somewhat urgent)
    ... MySQL server has a database with a table, ... columns, an FSR column, and a password column. ... checked if the supposed arrays that were returned were actually arrays ...
    (comp.lang.php)
  • RE: FreeBSD 5.3 MySQL Performance
    ... versions of Linux and FreeBSD for most tests. ... > popular with the ATA disk drive manufacturers. ... > Many companies have used FreeBSD and MySQL for years and years. ... it is not often that you have such a small database and such a large ...
    (freebsd-questions)
  • ANN: Database Designer for MySQL version 1.6 is released
    ... The new version 1.6 of MicroOLAP Database Designer for MySQL has been ... The secure shell (SSH) tunneling is now implemented in Database ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: toolkits or APIs to create a web interface as a frontend to mysql
    ... I am also *not* looking for a web based full fledged mysql client. ... For simple display of tabulated data the most useful thing is a displaywhich uses 's with absolute coordinates to position text in a box of defined width, formatted to be left, right or center justified, an using a preselected style from a a style sheet. ... As far as the actual database calls go, those are specific to each form, and apart from a little coding so that 'database_open, database_close' exist in the library, taking such things as the database name, user name and password from an included file I find it easiest to simply do the query and iterate through it to display the data requested. ...
    (comp.os.linux.misc)
  • Re: PICK OPENDB provides connection in shopping cart startup
    ... we MIS folks are required to take on tasks that we don't ... developer, nor the database. ... Why do you need MySQL?. ... in size that KTP experienced, evolving to the current 90,000+ sq. ...
    (comp.databases.pick)