SQL console

Do not post support requests, bug reports or feature requests. Discuss phpBB here. Non-phpBB related discussion goes in General Discussion!
Get Involved
Post Reply
User avatar
Frogmen
Registered User
Posts: 114
Joined: Fri Dec 28, 2007 11:48 pm
Location: Palma De Mallorca. Spain

SQL console

Post by Frogmen »

Hello, I have problems knowing what to do with the instructions at the bottom. Where do i found the sql console. I search on my cPanel and cant find anything to work my problem.
Naguissa wrote:
Fri Jan 31, 2020 6:58 am
Frogmen wrote:
Fri Jan 31, 2020 5:48 am
Yes. I have a back up. But if I use it I’ll loose last days messages. Is there a way to do it just copying some tables from the back up?

Slds
Javier
For these steps you need to change table prefix if your installation uses any other. It's the bold part of table name: phpbb_thanks

You need to execute these statments on a SQL console in your database server, selecting your phpbb installation database.

1) Disable the extension

2) Uncompress backup file and open resulting SQL file.

3) From that file, execute in your SQL console the lines after

Code: Select all

# Table: phpbb_thanks
There're three statements:

Code: Select all

DROP TABLE IF EXISTS phpbb_thanks;

Code: Select all

CREATE TABLE `phpbb_thanks` (
  `post_id` mediumint(8) unsigned NOT NULL DEFAULT 0,
  `poster_id` mediumint(8) unsigned NOT NULL DEFAULT 0,
  `user_id` mediumint(8) unsigned NOT NULL DEFAULT 0,
  `topic_id` mediumint(8) unsigned NOT NULL DEFAULT 0,
  `forum_id` mediumint(8) unsigned NOT NULL DEFAULT 0,
  `thanks_time` int(11) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`post_id`,`user_id`),
  KEY `post_id` (`post_id`),
  KEY `topic_id` (`topic_id`),
  KEY `forum_id` (`forum_id`),
  KEY `user_id` (`user_id`),
  KEY `poster_id` (`poster_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

Code: Select all

INSERT INTO phpbb_thanks [here comes all your data]
rgds
Javier

User avatar
Mick
Support Team Member
Support Team Member
Posts: 22083
Joined: Fri Aug 29, 2008 9:49 am
Location: Watching cricket.

Re: SQL console

Post by Mick »

"The more connected we get the more alone we become" - Kyle Broflovski

Please read: “Am I In The Right Place?” before posting.

User avatar
Naguissa
Registered User
Posts: 338
Joined: Thu Mar 02, 2017 6:55 am
Location: Barcelona
Name: Naguissa
Contact:

Re: SQL console

Post by Naguissa »

Did Mick's reply solved the issue?

User avatar
Frogmen
Registered User
Posts: 114
Joined: Fri Dec 28, 2007 11:48 pm
Location: Palma De Mallorca. Spain

Re: SQL console

Post by Frogmen »

Yes Thks. The data was so big that I had a time out doing it on my side, but I send the script to my hosting and they did it for me, now all works ok.

Thks Mick and Naguissa.

Rgds
Javier

Post Reply

Return to “phpBB Discussion”