Find the answer to your Linux question:
Results 1 to 4 of 4
I'm running Fedora 8 as a server, and I recently tried to install phpBB3 for my website. Well I got about halfway through it, and then my browser timed out. ...
Enjoy an ad free experience by logging in. Not a member yet? Register.
  1. #1
    Just Joined!
    Join Date
    Apr 2008
    Location
    Georgia, US
    Posts
    53

    [SOLVED] Help with SQL


    I'm running Fedora 8 as a server, and I recently tried to install phpBB3 for my website. Well I got about halfway through it, and then my browser timed out. When I started at the beginning again. I get an error saying that it has already written the files it needs. I removed the phpBB3 folder and re-downloaded it, and put it back on my server and started over. Same thing happened. I figure that it would be my SQL database since phpBB needs access to the database. Thankfully before I started installing phpBB I backed-up my SQL database. So I tried importing the old SQL database by doing:

    Code:
     mysqlimport -u username -p sql_database  old_sql_database.sql
    That didn't work so I tried:

    Code:
     mysql - u username -p sql_database < old_sql_database.sql
    That didn't work either. So now I'm at an impass. I either need to find someone who actually knows sql, unlike myself, or just recreate my database. I'd rather not recreate my database since I know no SQL what so ever. So here is what I'm dealing with. MySQL 5.0.45, Apache 2.2.6, and PHP 5.2.4. I don't have phpMyAdmin installed, but I do have ISPConfig installed and working properly. Thanks for any help.
    Last edited by Redman; 09-24-2008 at 06:27 PM.

  2. #2
    Just Joined!
    Join Date
    Oct 2007
    Posts
    66
    When you say 'it didn't work' regarding trying to rebuild your db, what do you mean? What error messages did you get when you ran these commands?

    I don't know anything about phpBB, but does it need access to MySQL server or a specific database on MySQL server? Is there a point where you configure phpBB to talk to that server?

    When you backed up your database did you use mysqldump (I expect you did, but just making sure)?

    Normally, when I rebuild a db with a backup dump, I run:
    mysql -uusername -p -Dschemaname --execute="source backup.sql"

    I've never used the other two commands that you show there, though, with a minor amount of research I imagine I'll find they do the same thing.

    BTW, 'recreating' a database is as simple as:
    mysql>create schema <schema_name>;
    mysql>source backup.sql;

    Lastly, this doesn't really seem like a Linux question. You will have better luck in a MySQL or phpBB forum, I think.

  3. #3
    Just Joined!
    Join Date
    Apr 2008
    Location
    Georgia, US
    Posts
    53
    Well Lazarus I found my problem and fixed it last night. To backup my database I used the backup feature in ISPConfig. I found the entries in my database though and went in and manually deleted. Then I checked everything with ISPConfig, did a repair database, that took care of anything that was left from deleting the entries. It worked, thanks though for trying to help. I had plenty of time to think about a way to fix it though last night. I think though I;m going to go get a SQL book now though to read.

  4. $spacer_open
    $spacer_close
  5. #4
    Linux Enthusiast
    Join Date
    Oct 2004
    Posts
    609
    Issue here doesn't specific concern Linux, but SQL.
    Topic closed.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •