MySQL

[GreG]

Hi erstma...

Ich habe da ein problem... Ich will artickel im sinne von

www.meineseite.de/index.php?artikel=1,5,6,7

oder in dieser art in eine inportierte tabelle laden! Jader artikel in eine einzelne tabelle.

Ich kenn mich aber nicht so recht mit My SQL aus und wollte mal fragen ob ihr mir irgentwie helfen könnt so das ich nicht gleich wieder vor lauter problemen stehe...

[Chris]

Du kommst nicht darum, Dich ein bischen mit DBs zu beschäftigen.

Die Aussage "jeden Artikel in eine Tabelle" läst jedenfalls darauf schliessen Oder schau mal in Netz rum ... stichwort Normalisierung.

Chris

[GreG]

normalisirung hilft mir ja nix wenn ich nicht mal weiss in welcher weise ich die daten und reienvolge bei phpmyadmin einfügen soll

Ausserdem geht mein mysql bei Wampp 2.1 immer nach etwa 10 sekunden aus...als kann ich damit ja so oder so nicht anfangen...

Weiss vieleicht einer wieso das mit meinem mysql so is und was is dagegen tun kann???

[Chris]

Schau mal hier:

http://www.little-idiot.de/mysql/

Da hast du ne gute Einführung, wie man DB unter MySQL sinnvoll anlegt.

Ausserdem kannst du mal in deine my.ini schauen. (win root Verzeichniss) Dort sind einige Parameter. Man kann auch noch weitere modifizieren. Siehe Doku.

Bist Du Dir sicher, dass die DB dich kickt? (Und nicht der HTTP Server bzw PHP?)

Chris

[GreG]

ich weiss nicht wer oder was mich kickt ... danke für die addy!

Ich find diese my.ini nicht...hab den ganzen PC auf den kopf gestellt...lol
Vieleicht guchste dir ja mein log an:



[Mon Apr 14 13:08:22 2003] [notice] Parent: Received shutdown signal -- Shutting down the server.
[Mon Apr 14 13:08:22 2003] [notice] Child 2992: Exit event signaled. Child process is ending.
[Mon Apr 14 13:08:23 2003] [notice] Child 2992: Released the start mutex
[Mon Apr 14 13:08:28 2003] [notice] Child 2992: Waiting for 250 worker threads to exit.
[Mon Apr 14 13:08:28 2003] [notice] Child 2992: All worker threads have exited.
[Mon Apr 14 13:08:28 2003] [notice] Child 2992: Child process is exiting
[Mon Apr 14 18:53:41 2003] [notice] Parent: Created child process 3316
[Mon Apr 14 18:54:10 2003] [notice] Child 3316: Child process is running
[Mon Apr 14 18:54:10 2003] [notice] Child 3316: Acquired the start mutex.
[Mon Apr 14 18:54:10 2003] [notice] Child 3316: Starting 250 worker threads.
[Mon Apr 14 19:03:46 2003] [notice] Parent: Received shutdown signal -- Shutting down the server.
[Mon Apr 14 19:03:46 2003] [notice] Child 3316: Exit event signaled. Child process is ending.
[Mon Apr 14 19:03:47 2003] [notice] Child 3316: Released the start mutex
[Mon Apr 14 19:03:48 2003] [notice] Child 3316: Waiting for 250 worker threads to exit.
[Mon Apr 14 19:03:48 2003] [notice] Child 3316: All worker threads have exited.
[Mon Apr 14 19:03:48 2003] [notice] Child 3316: Child process is exiting
[Mon Apr 14 19:03:48 2003] [notice] Parent: Child process exited successfully.
[Mon Apr 14 19:12:31 2003] [notice] Parent: Created child process 3552
[Mon Apr 14 19:12:59 2003] [notice] Child 3552: Child process is running
[Mon Apr 14 19:13:00 2003] [notice] Child 3552: Acquired the start mutex.
[Mon Apr 14 19:13:00 2003] [notice] Child 3552: Starting 250 worker threads.
[Mon Apr 14 19:13:52 2003] [notice] Parent: child process exited with status 1 -- Restarting.
[Mon Apr 14 19:14:09 2003] [notice] Parent: Created child process 2620
[Mon Apr 14 19:14:36 2003] [notice] Child 2620: Child process is running
[Mon Apr 14 19:14:36 2003] [notice] Child 2620: Acquired the start mutex.
[Mon Apr 14 19:14:36 2003] [notice] Child 2620: Starting 250 worker threads.
[Mon Apr 14 19:16:52 2003] [notice] Parent: Created child process 1308
[Mon Apr 14 19:17:22 2003] [notice] Child 1308: Child process is running
[Mon Apr 14 19:17:22 2003] [notice] Child 1308: Acquired the start mutex.
[Mon Apr 14 19:17:22 2003] [notice] Child 1308: Starting 250 worker threads.
[Mon Apr 14 19:19:43 2003] [notice] Parent: Received shutdown signal -- Shutting down the server.
[Mon Apr 14 19:19:43 2003] [notice] Child 1308: Exit event signaled. Child process is ending.
[Mon Apr 14 19:19:44 2003] [notice] Child 1308: Released the start mutex
[Mon Apr 14 19:19:45 2003] [notice] Child 1308: Waiting for 250 worker threads to exit.
[Mon Apr 14 19:19:45 2003] [notice] Child 1308: All worker threads have exited.
[Mon Apr 14 19:19:45 2003] [notice] Child 1308: Child process is exiting
[Mon Apr 14 19:19:45 2003] [notice] Parent: Child process exited successfully.
[Mon Apr 14 19:20:21 2003] [notice] Parent: Created child process 3604
[Mon Apr 14 19:20:49 2003] [notice] Child 3604: Child process is running
[Mon Apr 14 19:20:49 2003] [notice] Child 3604: Acquired the start mutex.
[Mon Apr 14 19:20:49 2003] [notice] Child 3604: Starting 250 worker threads.
[Mon Apr 14 19:21:28 2003] [notice] Parent: Received shutdown signal -- Shutting down the server.
[Mon Apr 14 19:21:28 2003] [notice] Child 3604: Exit event signaled. Child process is ending.
[Mon Apr 14 19:21:29 2003] [notice] Child 3604: Released the start mutex
[Mon Apr 14 19:21:30 2003] [notice] Child 3604: Waiting for 250 worker threads to exit.
[Mon Apr 14 19:21:30 2003] [notice] Child 3604: All worker threads have exited.
[Mon Apr 14 19:21:30 2003] [notice] Child 3604: Child process is exiting
[Mon Apr 14 19:21:30 2003] [notice] Parent: Child process exited successfully.
[Mon Apr 14 19:22:03 2003] [notice] Parent: Created child process 1684
[Mon Apr 14 19:22:35 2003] [notice] Child 1684: Child process is running
[Mon Apr 14 19:22:35 2003] [notice] Child 1684: Acquired the start mutex.
[Mon Apr 14 19:22:35 2003] [notice] Child 1684: Starting 250 worker threads.
[Mon Apr 14 19:22:58 2003] [notice] Parent: child process exited with status 1 -- Restarting.
[Mon Apr 14 19:23:34 2003] [notice] Parent: Created child process 1948
[Mon Apr 14 19:24:00 2003] [notice] Child 1948: Child process is running
[Mon Apr 14 19:24:00 2003] [crit] (OS 109)Die Pipe wurde beendet. : setup_inherited_listeners: Unable to read socket data from parent
[Mon Apr 14 19:24:29 2003] [notice] Parent: Created child process 2112
[Mon Apr 14 19:25:05 2003] [notice] Child 2112: Child process is running
[Mon Apr 14 19:25:05 2003] [notice] Child 2112: Acquired the start mutex.
[Mon Apr 14 19:25:05 2003] [notice] Child 2112: Starting 250 worker threads.
[Mon Apr 14 19:40:31 2003] [notice] Parent: Received shutdown signal -- Shutting down the server.
[Mon Apr 14 19:40:31 2003] [notice] Child 2112: Exit event signaled. Child process is ending.
[Mon Apr 14 19:40:32 2003] [notice] Child 2112: Released the start mutex
[Mon Apr 14 19:40:33 2003] [notice] Child 2112: Waiting for 250 worker threads to exit.
[Mon Apr 14 19:40:33 2003] [notice] Child 2112: All worker threads have exited.
[Mon Apr 14 19:40:33 2003] [notice] Child 2112: Child process is exiting
[Mon Apr 14 19:40:33 2003] [notice] Parent: Child process exited successfully.
[Mon Apr 14 21:25:05 2003] [notice] Parent: Created child process 2264
[Mon Apr 14 21:25:35 2003] [notice] Child 2264: Child process is running
[Mon Apr 14 21:25:35 2003] [notice] Child 2264: Acquired the start mutex.
[Mon Apr 14 21:25:35 2003] [notice] Child 2264: Starting 250 worker threads.
[Mon Apr 14 23:28:27 2003] [notice] Parent: Received shutdown signal -- Shutting down the server.
[Mon Apr 14 23:28:27 2003] [notice] Child 2264: Exit event signaled. Child process is ending.
[Mon Apr 14 23:28:28 2003] [notice] Child 2264: Released the start mutex
[Mon Apr 14 23:28:29 2003] [notice] Child 2264: Waiting for 250 worker threads to exit.
[Mon Apr 14 23:28:29 2003] [notice] Child 2264: All worker threads have exited.
[Mon Apr 14 23:28:29 2003] [notice] Child 2264: Child process is exiting
[Mon Apr 14 23:28:29 2003] [notice] Parent: Child process exited successfully.
[Tue Apr 15 17:05:19 2003] [notice] Parent: Created child process 3932
[Tue Apr 15 17:05:53 2003] [notice] Child 3932: Child process is running
[Tue Apr 15 17:05:53 2003] [notice] Child 3932: Acquired the start mutex.
[Tue Apr 15 17:05:53 2003] [notice] Child 3932: Starting 250 worker threads.
[Tue Apr 15 17:26:12 2003] [notice] Parent: Received shutdown signal -- Shutting down the server.
[Tue Apr 15 17:26:12 2003] [notice] Child 3932: Exit event signaled. Child process is ending.
[Tue Apr 15 17:26:13 2003] [notice] Child 3932: Released the start mutex
[Tue Apr 15 17:26:14 2003] [notice] Child 3932: Waiting for 250 worker threads to exit.
[Tue Apr 15 17:26:14 2003] [notice] Child 3932: All worker threads have exited.
[Tue Apr 15 17:26:14 2003] [notice] Child 3932: Child process is exiting
[Tue Apr 15 17:26:14 2003] [notice] Parent: Child process exited successfully.
[Tue Apr 15 22:13:09 2003] [notice] Parent: Created child process 3248
[Tue Apr 15 22:13:36 2003] [notice] Child 3248: Child process is running
[Tue Apr 15 22:13:36 2003] [notice] Child 3248: Acquired the start mutex.
[Tue Apr 15 22:13:36 2003] [notice] Child 3248: Starting 250 worker threads.
[Tue Apr 15 22:18:57 2003] [notice] Parent: Received shutdown signal -- Shutting down the server.
[Tue Apr 15 22:18:58 2003] [notice] Child 3248: Exit event signaled. Child process is ending.
[Tue Apr 15 22:18:59 2003] [notice] Child 3248: Released the start mutex
[Tue Apr 15 22:19:00 2003] [notice] Child 3248: Waiting for 250 worker threads to exit.
[Tue Apr 15 22:19:00 2003] [notice] Child 3248: All worker threads have exited.
[Tue Apr 15 22:19:00 2003] [notice] Child 3248: Child process is exiting
[Tue Apr 15 22:19:00 2003] [notice] Parent: Child process exited successfully.
[Tue Apr 15 23:06:54 2003] [notice] Parent: Created child process 408
[Tue Apr 15 23:07:25 2003] [notice] Child 408: Child process is running
[Tue Apr 15 23:07:25 2003] [notice] Child 408: Acquired the start mutex.
[Tue Apr 15 23:07:25 2003] [notice] Child 408: Starting 250 worker threads.
[Tue Apr 15 23:43:30 2003] [notice] Parent: Received shutdown signal -- Shutting down the server.
[Tue Apr 15 23:43:30 2003] [notice] Child 408: Exit event signaled. Child process is ending.
[Tue Apr 15 23:43:31 2003] [notice] Child 408: Released the start mutex
[Tue Apr 15 23:43:32 2003] [notice] Child 408: Waiting for 250 worker threads to exit.
[Tue Apr 15 23:43:32 2003] [notice] Child 408: All worker threads have exited.
[Tue Apr 15 23:43:32 2003] [notice] Child 408: Child process is exiting
[Tue Apr 15 23:43:32 2003] [notice] Parent: Child process exited successfully.
[Wed Apr 16 15:28:24 2003] [notice] Parent: Created child process 2436
[Wed Apr 16 15:28:56 2003] [notice] Child 2436: Child process is running
[Wed Apr 16 15:28:56 2003] [notice] Child 2436: Acquired the start mutex.
[Wed Apr 16 15:28:56 2003] [notice] Child 2436: Starting 250 worker threads.
[Wed Apr 16 15:30:07 2003] [notice] Parent: Received shutdown signal -- Shutting down the server.
[Wed Apr 16 15:30:07 2003] [notice] Child 2436: Exit event signaled. Child process is ending.
[Wed Apr 16 15:30:08 2003] [notice] Child 2436: Released the start mutex
[Wed Apr 16 15:30:09 2003] [notice] Child 2436: Waiting for 250 worker threads to exit.
[Wed Apr 16 15:30:09 2003] [notice] Child 2436: All worker threads have exited.
[Wed Apr 16 15:30:09 2003] [notice] Child 2436: Child process is exiting
[Wed Apr 16 15:30:09 2003] [notice] Parent: Child process exited successfully.