I've had a few queries that worked strangely worked in Mysql monitor,
but did not work from PHP.
I was able to solve every one of them by ensure that the query in PHP did
not have any line breaks in it. It normally doesn't matter if there are
line breaks in the code, but on occassion, a line
Looks to me like a permissions problem. If you were manipulating the
MYSQL files as root or if you copied or moved them, this could happen.
Look at the permissions on a "working" machine and match those on this
machine. The permissions need to allow changes, but too permissive
permissions will
If it were me, I'd create a new table in the database with enough columns
to handle all the data in the file. Then I'd do insert . . . . select
into the table that need the data.
Hope this helps,
Michael Ridinger
On Thu, 22 Mar 2001, Daniel Newman wrote:
> I've been looking into the help file
Some people use the method you are describing without using a
database. This is especially useful when working with tables. As most
know, using tables is great, however, you end up duplicating a lot of code
for the menus. This makes updating the menu someone difficult. Rather
than go through
Well,
My best method has been to do the following:
1. Dumb the existing database to a file: mysqldump databasename >
database.txt.
2. On the new machine, create the new database. create databasename
3. Copy the file (database.txt) to the new machine.
4. Type.. mysql databasename < data
If I could see the structure of the table with the name of the key field,
I may be able to help.. otherwise, there's just not enough info.
Thanks,
Michael Ridinger
On Fri, 9 Mar 2001, Gerald L. Clark wrote:
> I would suggest that if you really want help, you should at least supply
> a little i