67 replies to this topic

[Sacred]

China J, on Mar 10 2008, 05:55 PM, said:

@ Sacred - You don't have to explain yourself as your question was directed to M4rtin only. Just wait for his reply or contact him via PM privately.

i love you <3

[Michael]

I chose not to use FileZilla. I don't see the point in it personally since the files are already on my computer. I just edit them and save them, and the changes show up immediately. Unless I'm missing the point of using FileZilla? I'm sure that's completely possible.

[China J]

The only reason I think I'm used to filezilla is because you get to see your server folder at the same time navigate any other folder on computer. Editing files on computer kind of slows me down because its troublesome to go back and forth between multiple windows. If it's just a solo file before I even think about it, yes I will just edit from there. But if I start looking at server structure for any reason then more than likely all the remaining files will be opened in filezilla for preview, editing and etc.

As Mike said you can edit directly on computer... I guess by your earlier post, you are used to ftp way of things which will take a bit to get used to if you are addicted to ftp.

[Sacred]

@ChinaJ maybe u can use Explore mode?! will look exactly like Fillzilla?

Click on Start menu > all programs > Accessories > Internet Explorer (don't just open IE the browser) Do it as i say exactly!

yes Michael you are absolutely right I also was wonder why is sandi have soo much problems and getting into too much hassle with the worst FTP program ever?

[Sandi]

Michael, on Mar 11 2008, 08:18 AM, said:

I chose not to use FileZilla. I don't see the point in it personally since the files are already on my computer. I just edit them and save them, and the changes show up immediately. Unless I'm missing the point of using FileZilla? I'm sure that's completely possible.

I don't care to use Filezilla either as I get shut out on long uploads for too many connections. I think it's a quirk of the software that doesn't close finished connections properly. Anyway lately I've been using CuteFTP.

The only reason I wanted to get Filezilla working locally was because I needed to CHMOD some files on the local server. CuteFtp will only allow me to change permissions on the server (??because local isn't a UNIX environment??). I'm sure that there is a way, or a program around, to change file permissions locally, but haven't gotten around to checking yet.

However I got the job done for what I need now, albeit in a round-a-bout way. I ftp'd the files to the server, set the CHMODs needed for install and sent them back to the computer.

For future reference if anyone knows how to set permissions on local files, I would be grateful to hear them.

[China J]

He he he... I love filezilla But that's another topic. Is file perms needed on local, I can't remember as your local server should be full throttle with no restrictions cause you are testing right?

[Sandi]

China J, on Mar 11 2008, 04:06 PM, said:

He he he... I love filezilla But that's another topic. Is file perms needed on local, I can't remember as your local server should be full throttle with no restrictions cause you are testing right?

Thanks China. I'm not up to par on UNIX, but I know now that windows doesn't understand CHMOD. Next time I install a program locally that wants files CHMOD'd I will ignore it and carry on.

[Musalman]

Quote

Or you may use your IP address assigned by your router. By using that IP, other people in your network will be able to use the forum installed on your machine. To find out what your local IP is, type "cmd.exe /k ipconfig" in Start -> Run (Win+R). The IP may be something like 192.168.1.1, 10.0.0.1 etc. And the URL to your forum is now http://youIP/forums/. You HAVE to use this address when installing the board. If you didn't, you have to do a little edit to conf_global.php (which is located in the forums root directory).

Find:
CODE
$INFO['board_url'] = "http://localhost";

Change it to:
CODE
$INFO['board_url'] = "http://your-local-IP";

Save.

Great Work m4rtin ... i hope this is really usefull

[Sandi]

Need some help. Almost all mods are done on my localhost server first (IP.Board V2.3.4). In order to keep the environment the same as much as possible I decided to add each mod that is on my live forum to the localhost server. It is working out pretty well, except that I don't have much of a database to work with. Just two members and a test post, which looks a lot different when I compare them.

I suppose I could add fake members and more test posts, but if possible I would like to import the mysql database from my live forum. They both have the same mods. I've checked and they both have 111 tables,so won't the only difference be the table size?

Can this be done by exporting then importing to XXAMP? If not I suppose I could wipe out IPB on the local host and import/move the entire forum.

[Sacred]

yes it is
XAAMP uses phpMyAdmin just like the real site


That's why we all recommend if ur having an upgrade do it on ur local host then just upload to the live site when ur done!

EDIT::
Seems like Some ppl are slow so edited phpMyAdmin for them

Edited by Sacred, 09 April 2008 - 08:58 PM.

[Kerry]

Sacred, on Apr 9 2008, 08:06 PM, said:

XAAMP uses MyAdminphp just like the real site

Would that be phpMyAdmin

[Sandi]

Excellent.

Now, I have backed up both databases. The live forum in cPanel and ACP. The localhost with ACP and myphpadmin.

However when I export my localhost db in phpmyadmin, it completes the process without asking for a location, so I have no idea where it put the backup. I need a backup first in case the import doesn't go well.

Oh and BTW what good is DB backup in ACP when there is no tool there to restore it? At least no tool to restore it under SQL Management.

[Kerry]

Just do a search for the backup (IE: if you saved it as .sql search for *.sql)

If your using IE then it peobabley went into your "My documents" folder

[Sandi]

Kerry, on Apr 9 2008, 04:21 PM, said:

Just do a search for the backup (IE: if you saved it as .sql search for *.sql)

If your using IE then it peobabley went into your "My documents" folder

Already tried that. There are only two *.sql files from today, the two backups I made from ACP. The export doesn't ask for a filename or express the extension it uses. However the problem was that I didn't tic a "Save as file" box which I took to mean other than *.sql. Curiosly it still goes thorugh the motions without an error when you click GO.

I have it exported now, and tried importing my regular forum DB. Now I have the big dump problem because the new DB is about 17 megs. It refers me to the documentation which is pretty vague, but it looks like I may be able to get around it.

If you have shell (command line) access, use MySQL to import the files directly. You can do this by issuing the "source" command from within MySQL: source filename.sql.

So next I guess I will figure out how to use the MyPHPadmin shell command line and issued the "source command." I may be back.

Edited by Sandi, 09 April 2008 - 10:07 PM.

[Sandi]

Not having any luck learning the command line needed in my post above. But because import recognizes zip compression, I tried to sneak around it by compressing the 17.2meg db into a 2.4meg zip. No go.

[indent]Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 17606213 bytes) in C:\xampp\phpMyAdmin\libraries\import.lib.php on line 262[/indent]

I have 2 gigs of ram, there must be a config file somewhere in XXAMP that I can edit to raise the import limit (Max: 16,384 KiB) a bit. I only need a little more than a meg more.

[Sacred]

"-Calypso-" said:

Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 184320 bytes) in /home/public_html/forum/sources/ipsclass.php(2073) : eval()'d code on line 877


The error maybe slightly different depending on the site but the problem is that a process with IPB (or a modification) is attempting to use more memory than the server configuration will allow for.

Open: init.php (should be where your conf_global.php file is)

Find:
CODE
//-----------------------------------------------
// NO USER EDITABLE SECTIONS BELOW
//-----------------------------------------------


Add Directly Above:
CODE
ini_set("memory_limit","64M");


If this does not work, contact your host and ask them to raise your memory_limit in you php.ini file.

[Sacred]

also for the back up thing


goto phpmyadmin choose the database you wanna back up > click export > then MARK where it says Save as File then Click Go
it will let u choose where to place ur DB


Edit:: ahh u found it already!



lol nice avatar

Edited by Sacred, 09 April 2008 - 11:09 PM.

[Sandi]

No go Sacred.

Any other suggestions?

[Sandi]

Well this is a fine kettle of fish. I thought I finally had it solved. I used MyPHPadmin export instead of cPanel backup to save my regular forum database. The file size was smaller (15.3meg instead of 17.2meg) easily small enough to fit within the 16.3meg file size limit.

It runs long enough to import 80 of the 111 tables, then stops with telling me that it timed out. But that if I resubmit the same file for import it will continue where it stopped. No such luck. Submitting the same file for import give me the error below:



WTF!

I have never cared for working with any database... now I am beginning to hate it!

[Sandi]

Ok help importing the large database is going nowhere, let me try a different tact.

I did a complete backup of my online host last night: forums (3) and blogs (4) and wish to just transfer it all to my localhost. It should be just like moving to another server, no?

Although I did notice that the directory structure is a bit different. My host has the mysql directory 2 dir above the data ( public_html then homedir then mysql dir ), while localhost has the mysql dir up only one dir ( htdocs ) above the data.

Can I place everything below public_html in htdocs, and then replace the localhost mysql directory with the host mysql directory? I realize some paths will have to be edited.

Edit: It looks like this won't work either. Probably because my host is Linux and my localhost is Windows. I also have XXAMP on my Linux computer but have never been able to get it to work.

The mysql files are not the same. My host stores them as a single file. My localhost stored each MySql table as a separate file. Agrggghh!

Back to the drawing board. Any help appreciated.

Edited by Sandi, 10 April 2008 - 09:11 PM.