iB::Topic::COMPAQ LAPTOP - WEB SERVER and MYSQL WITH PHP

	Damn Small Linux :: Damn Small Linux Board The DSL Forums

» Welcome Guest
[ Log In :: Register ]

Damn Small Linux Board » Damn Small Linux » User Feedback » COMPAQ LAPTOP - WEB SERVER and MYSQL WITH PHP

		Mini-ITX Boards Sale, Fanless BareBones Mini-ITX, Bootable 1G DSL USBs, 533MHz Fanless PC <-- SALE $200 each!
		Get The Official Damn Small Linux Book. DSL Market , Great VPS hosting provided by Tektonic

Pages: (7) </ 1 2 3 4 5 [6] 7 >/

[ Track this topic :: Email this topic :: Print this topic ]

Topic: COMPAQ LAPTOP - WEB SERVER and MYSQL WITH PHP

< Next Oldest | Next Newest >

NewDude

Group: Members
Posts: 150
Joined: Feb. 2006

Posted: April 27 2006,01:29

I have tried and have run into lots of problems with sql errors.

It seems phpbb doesn't create and good backup script.

When I tried importing it in, I run into several SQL Insert command errors. I got tired of messing with it.

Don't worry, I won't make the same mistake again...

The forum that is up is the forum that will always be....

charliez

Group: Members
Posts: 33
Joined: April 2006

Posted: April 28 2006,14:02

phpBB backup from their control panel only backs up the tables that are native to the phpBB distribution package.

When you do customizations to your phpBB that add new tables you need to use alternate methods to get a fully restorable db backup.

There are mods you can use to capture additional tables you add.

There is phpMyAdmin for smaller db's but is mention phpMyAdmin fails after a certain size. My db is just under 50 MB's and I restore frequently with no posts loss. (fyi - I'm not running phpMyAdmin under DSL but am in debian)

Or there is the native mysql command line arguments that will give you a full insert dump.

NewDude

Group: Members
Posts: 150
Joined: Feb. 2006

Posted: April 28 2006,17:12

I didn't customize my phpbb db at all. Never added more tables. I first tried the phpbb admin restore feature and couldn't restore it...got a lot of SQL errors..

Then I tried the phpadmin, it failed to. I probably could have done it if I was so impatient... I was getting mainly insert errors...

I am very good with SQL. I work with Oracle for work at day long, so it wasn't that I don't know SQL. I just got tired of messing with it.

The DB was only 1.4mb compressed...I think the limit with phpadmin is 2mb...so I was underthe limit.

hs7sv

Group: Members
Posts: 247
Joined: June 2005

Posted: July 07 2006,07:07

I'm testing XAMPP-1.5.3a and PHP-Nuke on DSL-2.4. phpmyadmin works fine. I can create, export and import database.

I'm using GRUB Frugal with option: opt=hda3.
Folder /tmp needs to be able to Read/Write for XAMPP. Then, I added the following into /opt/bootlocal.sh

Code Sample

sudo chmod go+rw /tmp
sudo /opt/lampp/lampp start

--------------
"My advice is to just return hardware that does not work with a plain Linux kernel, right to the place where you bought it, and ask for your money back..."

Klaus Knopper

newby

Group: Members
Posts: 171
Joined: June 2006

Posted: July 10 2006,16:45

Quote (NewDude @ Mar. 30 2006,22:50)

I am starting to try to learn Mosix to. I have been reading and trying to learn it and I want to get Mosix running on my network as a test. Maybe this summer I can get 2 test boxes together and test Mosix and try to get it going with DSL.

MOSIX

Definately keep us updated on Mosix. Whether one wants to take part in SETI or has a cool distributed app they want to write, I'm sure there are a number of us who are interested.

BTW, it looks like Mosix will require some mods to the kernel. Fortunately, it's the same version.

30 replies since Mar. 30 2006,18:16

< Next Oldest | Next Newest >

[ Track this topic :: Email this topic :: Print this topic ]

Pages: (7) </ 1 2 3 4 5 [6] 7 >/

Damn Small Linux Board » Damn Small Linux » User Feedback » COMPAQ LAPTOP - WEB SERVER and MYSQL WITH PHP