Welcome Guest ( Log In | Register)



 
 Reply to this topicStart new topic
> Mysql Help
DogEater008
post Nov 19 2005, 12:55 AM
Post #1


Super Member
*********

Group: Members
Posts: 383
Joined: 8-October 05
Member No.: 12,656
I tried to upgrade my coppermine photogallery by usiing fantastico, and but then it gave me an error.. i tried to follow their instructions to reinstall the backup, but i need help.

If you don't have SSH access, ask support to help you:
- Remove the directory /home/blah1234/public_html/forum
- Untar /home/blah1234/fantastico_backups/forum.backup.1132357531.tgz
- Empty the database blah1234_smf1
- Import the file /home/blah1234/fantastico_backups/forum/backup.sql into the database blah1234_smf1
- Move /home/blah1234/fantastico_backups/forum to /home/blah1234/public_html/forum

My question is, how do you empty the database and import the backup.sql file? I tried to download the backup.sql file to my computer, and i tried to view it with notepad, but nothing appeared.

Will any of my data get lost? Right now my disk space is -0.04 mb.

(list)

Go to the top of the page
 
+Quote Post
DogEater008
post Nov 20 2005, 12:28 AM
Post #2


Super Member
*********

Group: Members
Posts: 383
Joined: 8-October 05
Member No.: 12,656
i deleted my smf database but i made a backup sql file.. but for some reason. .it doesn't show the "connection strings"

for example (this is the connection strings for a different database)

CODE
Connection Strings
Perl $dbh = DBI->connect("DBI:mysql:blah1234_auct1:localhost","blah1234_auct1","<PASSWORD HERE>");
PHP $dbh=mysql_connect ("localhost", "blah1234_auct1", "<PASSWORD HERE>") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("blah1234_auct1");  
JDBC (may not be available)

<%@ page import="java.sql.*" %>
              Connection connection = null;
              Class.forName("org.gjt.mm.mysql.Driver").newInstance();
              connection = DriverManager.getConnection(
                 "jdbc:mysql://localhost/blah1234_auct1?user=blah1234_auct1&password=<PASSWORD HERE>");


I restored the database, but for some reason i still get this error

Connection Problems
Sorry, SMF was unable to connect to the database. This may be caused by the server being busy. Please try again later.

(list)

Go to the top of the page
 
+Quote Post
« Next Oldest · Questions & Queries · Next Newest »
 

Reply to this topicStart new topic

Collapse

> Similar Topics

Topics Topics
  1. Mysql Hostname?(4)
  2. Mysql Server Problem(3)
  3. Help With Php And Mysql Database(2)
  4. Login And Registration Mysql Problems(2)
  5. Mysql Problems....(4)
  6. Lost Connection To Mysql Server During Query(0)
  7. Php & Mysql Help(2)
  8. Mysql Database Size(6)
  9. Free Mysql Hosting(6)
  10. Problem With Php(8)
  11. Trap17.com Mysql Databases(2)
  12. Looking For Free Hosting With Mysql, Php And More(4)
  13. Mysql And Free Hosting(8)
  14. Mysql Only(2)
  15. Mysql Help Needed(2)
  1. Which Mysql Version Does Trap17 Offer?(4)
  2. Fantastico Difficulties(1)
  3. I Cannot Connect To Mysql(1)
  4. External Access To Mysql Database(0)
  5. Mysql(5)
  6. Mysql Database Space(3)
  7. Please Explain Me Mysql(4)


 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

- Lo-Fi Version Time is now: 6th September 2008 - 06:24 AM
Powered By IP.Board © 2008  IPS, Inc.
Licensed to: Xisto Corporation