https://proxy2.de/forum/posts/list/3.php JForum - http://www.jforum.net
Thanks....

p.s.If we live in the same town(Kuala Lumpur), a beer's on me!]]> https://proxy2.de/forum/posts/preList/3580/10319.php https://proxy2.de/forum/posts/preList/3580/10319.php GMT
[list]1. On the old server, go into your Admin Panel, then PhpMyAdmin,
and Export the .sql file of your existing database to your hard drive:

[list:ddce079862] On the left (blue) pane, click in the database box and Select the guestbook's database

When it finishes loading, on the right pane, click on the "Export" tab

When it finishes loading, (somewhere towards the bottom) you will see:

(checkbox) Save as file File name template: (remember template )*

You must check the box for [b]Save as file[/b], then click on the GO button

Follow the prompts to save it to your hard drive or other disk. Remember where you put the file. This is a backup of your existing database. Try not to mix it up with any other .sql files from a new copy of version 2.3.1. Alternatively, you could add something in the box after [b]_DB_[/b] to identify it, example: Save as file File Name template: _DB_old or _DB_date. The saved copy will automatically include the host's required user prefix, if any and the database name.[/list]

2. On the new server, go to PhpMyAdmin and create a new guestbook database. (Be sure to add the required info in admin/config.inc.php and set file permissions according to the instructions in the readme file)

3. In PhpMyAdmin, populate the new database:

[list] As in #1 above, select the new guestbook's database in the left pane.

On the right window pane, click on the "SQL" tab

Find the Sql box (somewhere near the bottom?), click inside the box, then click on "browse" and navigate to the place on your hard drive where you put the .sql file you created earlier. Once you have navigated to that file and it is shown in the box, click on ok.

After processing the task, you should get a successful result. If successful, the guestbook tables will appear in the left (blue) pane.

If there is a problem, you will get an error message. If you get an error message, please make note of it for future help. [/list]

4. On the left (blue) pane, click on Home

5. On the right pane, select log out

6. Close out the PhpMyAdmin window without navigating anywhere else (for security reasons)[/list:u:ddce079862]

Typing this now from memory without any visual aids, so be careful.]]> https://proxy2.de/forum/posts/preList/3580/10326.php https://proxy2.de/forum/posts/preList/3580/10326.php GMT
Thanks for replying to my query and the long answer!

Ok, bit by bit the guestbook is starting to look like what it was before. I had problems earlier on with the images and some other data that couldn't display but managed to get it all back. However, when I try to alter the templates in admin, these error messages appear :-

Warning: fopen(./templates/body.php): failed to open stream: Permission denied in /home/littleno/public_html/guestbook/lib/admin.class.php on line 193

Warning: fwrite(): supplied argument is not a valid stream resource in /home/littleno/public_html/guestbook/lib/admin.class.php on line 194

Warning: fclose(): supplied argument is not a valid stream resource in /home/littleno/public_html/guestbook/lib/admin.class.php on line 200

Give write permissions to the webserver on the template files!



I can't understand the last message because I have upped permissions for most files to 755 and public, tmp to 777. As for the rest, it is beyond me. What can I do?

P.S.I don't understand PHP.]]> https://proxy2.de/forum/posts/preList/3580/10341.php https://proxy2.de/forum/posts/preList/3580/10341.php GMT https://proxy2.de/forum/posts/preList/3580/10342.php https://proxy2.de/forum/posts/preList/3580/10342.php GMT
http://proxy2.de/forum/viewtopic.php?t=2086&highlight=guestbook+templates+permissions

I have all the .class files at 644, which I believe is how they originally were.]]> https://proxy2.de/forum/posts/preList/3580/10344.php https://proxy2.de/forum/posts/preList/3580/10344.php GMT
/home/xxxxxx/public_html/guestbook/lib/admin.class.php on line 200]]> https://proxy2.de/forum/posts/preList/3580/10345.php https://proxy2.de/forum/posts/preList/3580/10345.php GMT
By the way, is it possible to x out my server info above? Made a mistake there.....]]> https://proxy2.de/forum/posts/preList/3580/10351.php https://proxy2.de/forum/posts/preList/3580/10351.php GMT
Auron]]> https://proxy2.de/forum/posts/preList/3580/10353.php https://proxy2.de/forum/posts/preList/3580/10353.php GMT

Can I use install.php to create the database on a new server or do I have to use PHPMyAdmin?

And if I can use install.php I'm assuming I would then just import the old database and overwrite the new one.]]> https://proxy2.de/forum/posts/preList/3580/10373.php https://proxy2.de/forum/posts/preList/3580/10373.php GMT isn't much point making a new one with the install file if your just
gonna overwrite it- to me that would be a complete waste of time.

- Auron]]> https://proxy2.de/forum/posts/preList/3580/10374.php https://proxy2.de/forum/posts/preList/3580/10374.php GMT
but...

[color="red"]MySQL Error : Query Error
Error Number: 1146 Table 'spec.book_config' doesn't exist[/color]

I assume this meabs the db needs to be set up, how do i do this?
I have used phpmyadmin once before but this host does not have it on the cpanel

Thanks]]> https://proxy2.de/forum/posts/preList/3580/10531.php https://proxy2.de/forum/posts/preList/3580/10531.php GMT
[quote] Or use the script 'install.php' -> http://www.yourDomain.com/guestbook/install.php[/quote]

After installation, be sure to remove the install.php file from your server.]]> https://proxy2.de/forum/posts/preList/3580/10539.php https://proxy2.de/forum/posts/preList/3580/10539.php GMT
the problem I have is that the old host did not have a gui interface, I only have FTP access to the server. So have no phpadmin or SQL manager.

When I ftp to the site where the GB is working, the only folder I can see which may relate to the SQL side of things is :

/var/Darren

in here are many file ending .frm/MTD/MYI

I cant find any sql file which holds all of the posts...therefore dont know what to export....

any help would be great.]]> https://proxy2.de/forum/posts/preList/3580/10568.php https://proxy2.de/forum/posts/preList/3580/10568.php GMT
[quote]I cant find any sql file which holds all of the posts...therefore dont know what to export....
[/quote]

You cant export anyway without php myadmin.]]> https://proxy2.de/forum/posts/preList/3580/10574.php https://proxy2.de/forum/posts/preList/3580/10574.php GMT https://proxy2.de/forum/posts/preList/3580/12972.php https://proxy2.de/forum/posts/preList/3580/12972.php GMT
I have a similar situation.

From what I am gathering, I do not need to check any boxes but go with the default to export my database correct?

Thanks
Dave]]> https://proxy2.de/forum/posts/preList/3580/20348.php https://proxy2.de/forum/posts/preList/3580/20348.php GMT
my guestbook in the Database block

Then I'm suppose to click on "export" on the right hand side. If I do this the way Amber said (a few posts up), in the "File name template area it says _SERVER_ and not _DB_ as Amber said.

Now, if I look in the documentation area (the question mark over the "database" block) do I have to check anything off in there before I export? Like on book_data or book_ip etc.

If I check these items off first and then click export, then the "File name template area says _DB_.

Hope I didn't confuse you.

I'm using Guestbook 2.3.1]]> https://proxy2.de/forum/posts/preList/3580/20911.php https://proxy2.de/forum/posts/preList/3580/20911.php GMT
So I chose import and get this message:

[b]Error

SQL query:

-- phpMyAdmin SQL Dump
-- version 2.8.0.2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jul 19, 2006 at 12:04 AM
-- Server version: 4.1.19
-- PHP Version: 4.4.2
--
-- Database: `dwoody_agbook1`
--
-- --------------------------------------------------------
--
-- Table structure for table `book_auth`
--
CREATE TABLE `book_auth` (
`ID` smallint( 5 ) NOT NULL AUTO_INCREMENT ,
`username` varchar( 60 ) NOT NULL default '',
`password` varchar( 60 ) NOT NULL default '',
`session` varchar( 32 ) NOT NULL default '',
`last_visit` int( 11 ) NOT NULL default '0',
PRIMARY KEY ( `ID` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =2;

MySQL said: Documentation
#1050 - Table 'book_auth' already exists
[/b]

Hope I didnt mess it up to bad.]]> https://proxy2.de/forum/posts/preList/3580/20937.php https://proxy2.de/forum/posts/preList/3580/20937.php GMT