|
|
Posted by MS on 06/06/05 16:01
> It occurs to me that you could include the database files with the
package,
> and have the configuration script copy them into the correct directory.
This
> is much faster than running it as queries, and you won't face the
drawbacks
> with copying the database a row at a time (or running it from a dump)
>
I would try this... But can you tell me where the database files are ?
Alex.
> If you are running insert queries, the cycle will take much longer as the
> database gets bigger, so you will reach a point where PHP timeouts
interfere
> with running the program. You can change the PHP timeouts, but then you
run
> into SQL timeouts - and so on :) The database I was working with required
> everything to be broken up into smaller pieces & restart the process after
a
> pause.
>
> Use mysql_create_db() to create the database. Creating a database in MySQL
> consists of MySQL creating a directory in the MySQL data folder. All you
> need to do after this is copy the 3 relevant database files into that
> folder. If they're included with the distribution files, this would be a
> simple matter.
>
> Hope that helps at least a little
>
>
Navigation:
[Reply to this message]
|