472,353 Members | 1,747 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,353 software developers and data experts.

Copying a table using phpMyAdmin.

2 phpbb boards I run have been hacked. One I've restored but the other one has had some damage to the MySQL db. A table is missing.

As it's a styles table I thought I could could copy a table, from a test board I set up, to the hacked board.

I tried this using phpMyAdmin and I get this error:

Expand|Select|Wrap|Line Numbers
  1. SQL-query: Edit
  3. CREATE TABLE `Tabcom`.`phpbb_styles_imageset_data` (
  4. `image_id` smallint( 4 ) unsigned NOT NULL AUTO_INCREMENT ,
  5. `image_name` varchar( 200 ) COLLATE utf8_bin NOT NULL default '',
  6. `image_filename` varchar( 200 ) COLLATE utf8_bin NOT NULL default '',
  7. `image_lang` varchar( 30 ) COLLATE utf8_bin NOT NULL default '',
  8. `image_height` smallint( 4 ) unsigned NOT NULL default '0',
  9. `image_width` smallint( 4 ) unsigned NOT NULL default '0',
  10. `imageset_id` smallint( 4 ) unsigned NOT NULL default '0',
  11. PRIMARY KEY ( `image_id` ) ,
  12. KEY `i_d` ( `imageset_id` ) ,
  13. FULLTEXT KEY `image_name` ( `image_name` ) ,
  14. FULLTEXT KEY `image_lang` ( `image_lang` ) ,
  15. FULLTEXT KEY `image_name_2` ( `image_name` )
  18. MySQL said: Documentation
  19. #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '79DEFAULT CHARSET  = utf8 COLLATE  = utf8_bin' at line 12 
Can you please help?

Oct 20 '08 #1
6 3333
802 Expert 512MB
Make sure you have space between 79 and DEFAULT in the last line of the statement i.e. 79DEFAULT
Oct 21 '08 #2
Make sure you have space between 79 and DEFAULT in the last line of the statement i.e. 79DEFAULT
Thanks for your quick reply.

However the line was generated by phpMyAdmin not by me; so I cannot correct it!
Oct 21 '08 #3
5,058 Expert 4TB
Can't you simply copy the SQL you posted here, add the space and execute the modified SQL in phpMyAdmin's SQL window?
Oct 21 '08 #4
Sorry for being so thick!

Where is the SQL window in phpMyAdmin?

Oct 21 '08 #5
5,058 Expert 4TB
If you select the database from the drop-down on the left, there should be a SQL tab at the top of the main window.
That should allow you to run any SQL query you need on the database.
Oct 21 '08 #6
Yes that worked!

I no longer get a db error but my board is still hacked.

Back to the phpbb help forum. :(

Thanks for being so patient with me.
Oct 22 '08 #7

Sign in to post your reply or Sign up for a free account.

Similar topics

by: Steve_EE | last post by:
I'm running phpMyAdmin 2.5.3 / MySQL 4.0.14 / PHP 4.3.3 / Apache 1.3.20 phpMyAdmin is installed and appears ok at first, I can login, select...
by: weldonj | last post by:
I upgraded to MySQL 4.1.1-alpha-standard the other night and ever since then at least twice a day my main message board table will crash. Here's...
by: Golf Nut | last post by:
This is a phpmyadmin question more than anything, but I hope someone may be able to help. When creating a dump of a normalized database with 26...
by: jaks | last post by:
How can I export a MySQL table with a different name using phpmyadmin? I want to export nuke_bbsearch_wordmatch and all it contents to...
by: Jim | last post by:
Hi, I want to add a field to a table in a database that is live and being accessed from the web. I'm using phpMyAdmin and when I try to add the...
by: news reader | last post by:
Hi, Does anoone of you know if there is already a simple application doing something like this. I would enhance / tune the missing features,...
by: Howard | last post by:
I have Apache Web Server 2.0.55 installed locally with MySQL 5.0.18-nt, and of course PHP 5.1.2 I also have installed phpMyAdmin. It is accessible...
by: shivendravikramsingh | last post by:
hi friends, i have a problem.i m using phptraid or php4 with mysql and phpmyadmin with apache in window XP my local machine.i hve used phpmyadmin...
by: GarryJones | last post by:
(I am sorry if this is the wrong group for this posting, I cant find a group on usenet for phpmyadmin, but maybe someone would be nice enough to...
by: Naresh1 | last post by:
What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge...
by: jalbright99669 | last post by:
Am having a bit of a time with URL Rewrite. I need to incorporate http to https redirect with a reverse proxy. I have the URL Rewrite rules made...
by: Matthew3360 | last post by:
Hi there. I have been struggling to find out how to use a variable as my location in my header redirect function. Here is my code. ...
by: Matthew3360 | last post by:
Hi, I have a python app that i want to be able to get variables from a php page on my webserver. My python app is on my computer. How would I make it...
by: AndyPSV | last post by:
HOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and on my computerHOW CAN I CREATE AN AI with an .executable...
by: Arjunsri | last post by:
I have a Redshift database that I need to use as an import data source. I have configured the DSN connection using the server, port, database, and...
by: WisdomUfot | last post by:
It's an interesting question you've got about how Gmail hides the HTTP referrer when a link in an email is clicked. While I don't have the specific...
by: BLUEPANDA | last post by:
At BluePanda Dev, we're passionate about building high-quality software and sharing our knowledge with the community. That's why we've created a SaaS...
by: Rahul1995seven | last post by:
Introduction: In the realm of programming languages, Python has emerged as a powerhouse. With its simplicity, versatility, and robustness, Python...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.