Re: Creating Mysql DB with PHP




"Tony" <someone@xxxxxxxxxxxxx> wrote in message
news:11a1fsljpfiao0a@xxxxxxxxxxxxxxxxxxxxx
> "MS" <nospamplaesegr8t_ukuk@xxxxxxxxxxx> wrote in message
> news:d7pmlp$5p2$1@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> >I am looking to create an install.php file which will create a mysql
> > database on the server the file is run.
> >
> > I have the SQL dump of the database structure and various prefilled
> > records,
> > but I want to automate the set up of the database name, password,
website
> > name etc...
> >
> > the install file would gather this setup information from the user/admin
> > and
> > create the mysql database accordingly.
> >
> > can anybody point me to instructions to do this?
> > any pitfalls I should be aware of?
> > any other relevant information?
> >
> > Thnx
> > Alex
>
> 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.

> 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.

Alex.


.

Relevant Pages

  • Re: hitting the limits
    ... relatively straight forward MySql database. ... 10K visitors a month and an 80Mb database are nothing. ... heavily loaded server. ... But the connection will hang around until the garbage ...
    (comp.lang.php)
  • Re: Database connection error (re-post)
    ... MySQL is a database server, it is not a desktop database like Access, you have to work with directly ... FrontPage Resources, WebCircle, MS KB Quick Links, etc. ...
    (microsoft.public.frontpage.client)
  • Re: Confusion about database updates
    ... all connecting to the same database server. ... MySQL can easily handle many simultaneous clients. ... AlphaCluster all open multiple connections to a MySQL server running on ... Let the MySQL server do that when your client ...
    (comp.lang.java.databases)
  • Re: MySQL Insert Unicode Problem
    ... I'm trying to insert some data from an XML file into MySQL. ... The database server has to support Unicode, ...
    (comp.lang.python)
  • Re: Using MySQL as the backend
    ... I need to learn MySQL, ... > the impression you're not familiar with the concept of a server DB. ... > doesn't need to have Access installed to access the database, ... >> install the server or maybe I have it installed but I just don't know how to ...
    (microsoft.public.access.tablesdbdesign)