PHPee.com PHP development forum
export to excel

 
Post new topic   Reply to topic    phpee.com Forum Index -> PPhlogger Support
View previous topic :: View next topic  
Author Message
lionel



Joined: 09 Dec 2003
Posts: 76

PostPosted: Tue Jun 01, 2004 9:14 pm    Post subject: export to excel Reply with quote
hey guys Smile

i came across this post about exporting to excel, only it's in german, anyone know if it works? how to use it?

http://forum.phpee.com/viewtopic.php?t=1067&highlight=excel

the first bit of code is in the 8th post

cheers

lionel Smile
Back to top
View user's profile Send private message
sdjl
Moderator


Joined: 17 Nov 2003
Posts: 823
Location: London, UK

PostPosted: Tue Jun 01, 2004 9:34 pm    Post subject: Reply with quote
Courtesy of Google:



It's not a great translation mind you, so someone who can do a direct German - English transaltion might be better at explaining if it works or not...

I don't think it worked, whatever it was.

I think you can export to Excel via PHPMyAdmin. Worth opening it on dathorn for your account and giving it a whirl Smile

David
_________________
-----
Free Logger Accounts | PPHlogger Manual | PM Me
Back to top
View user's profile Send private message Visit poster's website
lionel



Joined: 09 Dec 2003
Posts: 76

PostPosted: Wed Jun 02, 2004 2:46 pm    Post subject: Reply with quote
cheers David,

yeah i used babelfish but think i understood more of it when it wasin german Laughing

Just opened up phpmyadmin, it's the first time i've looked at my counter's tables and was shocked to find 2600 of them Shocked , does every user get a table? or two imagine, a logs table and mpdl.

Yeah i can export to csv for excel in phpmyadmin. Smile

cheers

Lionel
Back to top
View user's profile Send private message
Oliver341



Joined: 10 May 2004
Posts: 19
Location: Sussex, UK

PostPosted: Thu Jun 03, 2004 1:03 pm    Post subject: Reply with quote
lionel wrote:
Just opened up phpmyadmin, it's the first time i've looked at my counter's tables and was shocked to find 2600 of them Shocked , does every user get a table? or two imagine, a logs table and mpdl.

Yup, every user account in pphlogger gets 2 tables. It shouldn't be a problem though.

Oliver.
Back to top
View user's profile Send private message Visit poster's website
sdjl
Moderator


Joined: 17 Nov 2003
Posts: 823
Location: London, UK

PostPosted: Thu Jun 03, 2004 10:21 pm    Post subject: Reply with quote
Yes, two tables per account Smile

You've got a fair few users signed up for your account then!!

I think the most DB tables i have seen so far for a PPHLogger script is 64,000 Shocked
32,000 user accounts, quite a few really! Something like 30gigs of space just in the DB!

Oh, and the funny thing, they didn't protect their admin scripts Very Happy

David
_________________
-----
Free Logger Accounts | PPHlogger Manual | PM Me
Back to top
View user's profile Send private message Visit poster's website
lionel



Joined: 09 Dec 2003
Posts: 76

PostPosted: Wed Jun 09, 2004 11:26 pm    Post subject: Reply with quote
Ouch, open admin scripts,ooo.

Yeah i've managed to get quite a few, i'm no use at php, serverside, mysql etc, but seo is another thing Very Happy i'm getting 20 signups a day at the moment.

This has brought about problem though, although expected, my host (and yours david Wink) has asked me to move the site because it's got to resource intensive , his words were that it gets too much traffic and the php/mysql scripts with that amount of traffic are too intensive. So i've chosen dinix.com for a vps account.

Ok, moving the site. My plan, upload all the files (no probs), the database - will i be able to just download a database backup through cpanel and restore it at the new host ok? (i'll do this during the domain propagation seeing as there'll be no hits registering)


sheesh, 32 thousand users!!! that's quite a few.

cheers Smile
Back to top
View user's profile Send private message
sdjl
Moderator


Joined: 17 Nov 2003
Posts: 823
Location: London, UK

PostPosted: Thu Jun 10, 2004 12:19 am    Post subject: Reply with quote
I have a feeling cPanel or PhpMyAdmin will fail when trying to export such a large database.
I would suggest using some SSH commands to dump the database to a file. Then using SSH, ftp it to the other server, this way it uses your servers nice connections to the net and sends it a little bit faster than if you were doing from your home Smile

The following should work to dump a database:

You need to be logged into your SSH client already for this to work.
Code:

cd public_html

mysql -u USERNAMEHERE -p -D DATABASE_NAME > db_dump.sql


You will then be prompted for your MySQL DB password, enter it and the screen may look as if it has frozen, this is normal for large DB's.
You'll be returned to the command prompt.

To FTP the file from one server to another, look at using ncftp, which is installed at our hosts Smile

You should be able to get a list of commands to use with ncftp by typing:

Code:

ncftp --help


If you need more detail, just yell Smile

David
_________________
-----
Free Logger Accounts | PPHlogger Manual | PM Me
Back to top
View user's profile Send private message Visit poster's website
lionel



Joined: 09 Dec 2003
Posts: 76

PostPosted: Wed Jun 16, 2004 7:40 pm    Post subject: Reply with quote
Thanks David,

I was all set to give that a bash before i got the VPS setup, but when i got it WHM has a transfer account tool, where i just put int my current account's log in details, the account domain and hey presto, it transferred it all for me, settings and all!!

Waiting for my namerserver to resolve at the moment.

The transfer did miss a couple of files for some reason, a i know the server with the current domain had a little downtime when i was transferring so i imagine that was the cause.
I've replaced, i think, all the files that were missing, all of the modules folder was missing which caused the "calendar" section not to work at all, it's ok now apart from the graph's not showing, just getting a broken image red X, any ideas what would cause that, i can't seem to find any missing files.

cheers

Lionel
Back to top
View user's profile Send private message
sdjl
Moderator


Joined: 17 Nov 2003
Posts: 823
Location: London, UK

PostPosted: Wed Jun 16, 2004 7:50 pm    Post subject: Reply with quote
Is GD installed?
That would be the most likely cause.

Does the image for the counter show or is that broken too?
If that's broken, right click where the image should be, look at the properties. Copy the URL and paste it into a new browser window.

If there are any PHP errors, it will show there Smile Let me know if you want me to take a look.

David
_________________
-----
Free Logger Accounts | PPHlogger Manual | PM Me
Back to top
View user's profile Send private message Visit poster's website
lionel



Joined: 09 Dec 2003
Posts: 76

PostPosted: Thu Jun 17, 2004 4:47 pm    Post subject: Reply with quote
Bang on David Smile

seems the GD module isn't assigned as a default with apache, i just had recompile apache and select the module.

cheers mate Smile

lionel
Back to top
View user's profile Send private message
lionel



Joined: 09 Dec 2003
Posts: 76

PostPosted: Thu Jun 24, 2004 5:33 pm    Post subject: Reply with quote
hey david,

i didn't actually look at the counter image seeing as the GD library seemed to solve it, however the sample image gets a red X, and the php error it gives is:

Fatal error: Call to undefined function: imagettfbbox() in /home/counter/public_html/modules/image_gen.php on line 57


would that be another missing file?

cheers

lionel
Back to top
View user's profile Send private message
sdjl
Moderator


Joined: 17 Nov 2003
Posts: 823
Location: London, UK

PostPosted: Fri Jun 25, 2004 9:44 am    Post subject: Reply with quote
That would be GD still.
Make sure you have the TTF module enabled as well as anything listed in the manual Smile

http://pphlogger.phpee.com/doc.html

David
_________________
-----
Free Logger Accounts | PPHlogger Manual | PM Me
Back to top
View user's profile Send private message Visit poster's website
Post new topic   Reply to topic    phpee.com Forum Index -> PPhlogger Support All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB 2.0.8
Theme design based on Team 101 Designs, modified by Philip Iezzi