Lawrence Blades wrote:
> I tried to backup a table using select and fopen to write the data to a
> tab delimited file.
> The table has 1000 names with addresses.
> The execution quit after 30 seconds telling me it took too long.
> $result = mysql_query("SELECT * FROM whitepages ORDER BY lastname ");
> while ($row=mysql_fetch_row($result) )
> for ($counter=0; $counter<$num; $counter++)
> fputs ($myfile, "$row[$counter]\t\n");
> Question 1. Is the table too big for MySql capabilities?
> Question 2. I want to backup certain tables in my database (not ALL the
> tables, just selected ones).
> If I do mysqldump, I get them all, and not in the format I desire.
> Is there another way to backup a single table in tab delimited format?
> Lawrence Blades
> Digital Technologies
> P.O. Box 673
> Clarksdale, MS 38614
> Church Office: 601.624.6586
> COL Office: 601.627.5554
> FAX: 601.627.6797
> Home: 601-627-9539
> Cell: 601.621.3092
> (If you can't find me, I can't be found.)
Looks like there is something wrong with your set up. 1000 records on
any system should be a piece of cake to deal with. Try the following:
- du to see if maybe your disk is full
- tail your error logs, maybe there is some enlightening info in there
- isamchk your tables
Let us know what happens.