|
| |
|
|
womble
Posts: 5528
Joined: 3/14/2005
From: Living on the edge
Status: offline
 |
phpMyAdmin - 9/4/2006 16:37:55
Okay, Wombley's having a slight nervous breakdown here. Due to my web hosts being total idiots (and that's putting it potitely), I'm having to move some domains which include forums on them. No problem - in theory - I simply copy all the backed-up files to the new server and restore the database....hah! I wish it were so simple!
Due to an unavoidable delay in transfer domains I'm having to use the server's IP address to access my new account, but that's the least of my worries currently. I've been having problems using the phpMyAdmin that comes with my cPanel (doesn't help that I've no idea really how to use phpMyAdmin apart from following idiot-guide "how-to's" found online - and I thought phpMyAdmin was supposed to make b0rking dealing with MySQL easier!!!)
Anyway, following instructions found on phpBB (http://www.phpbb.com/kb/article.php?article_id=264) I've managed to install phpMyAdmin on my new account, and I can log into it and stuff and see that there's precisely no databases there at the moment, and I've set up and uploads directory that the database backuo's been ftp'd to, but I'm having problems importing the database.
I've set an upload directory and the database backup is coming up in the web server upload directory list, but when I press 'go' it either thinks about it endlessly and eventually I get an error message saying that a script on the page has stopped responding and an option to continue or stop script (pressing either does nothing), or I get the following message:
quote:
SQL query:
#
# phpBB Backup Script
# Dump of tables for ecanusn_phpbb3
#
# DATE : 04-09-2006 13:31:07 GMT
#
#
# TABLE: phpbb_auth_access
#
DROP TABLE IF EXISTS phpbb_auth_access;
MySQL said: Documentation
#1046 - No database selected
My skills at b0rking MySQLs is legendary, and I'm starting a db course in a month or so, so maybe then I'll have some sort of clue wtf it all means, but currently I've no idea what this means, or what I can do about it, and I am currently losing what few marbles I have left while ODing on caffeine and nicotine.
A desperate Wombley would be grateful for any ideas. 
_____________________________
~~ "A cruel god ain't no god at all" ~~
|
|
|
|
yb2
Posts: 653
Joined: 1/30/2006
Status: offline
|
RE: phpMyAdmin - 9/4/2006 17:22:02
I don't know anything about phpMyAdmin, but you need to add
Use youdatabasenamehere
go
at the top of the script before the DROP statement.
_____________________________
it is natural for people not to see one's own faults, and to exaggerate other people's faults and failings.
Currently listening to: L'Enfer Des Formes by Stereolab
| |
|
|
|
yb2
Posts: 653
Joined: 1/30/2006
Status: offline
|
RE: phpMyAdmin - 9/4/2006 17:58:25
if you get stuck but can run SQL directly then you could use something like this to set up the databases, and then you can run your imports.
IF NOT EXISTS myDatabaseNameHere THEN
CREATE DATABASE myDatabaseNameHere
END IF
go
_____________________________
it is natural for people not to see one's own faults, and to exaggerate other people's faults and failings.
Currently listening to: L'Enfer Des Formes by Stereolab
| |
|
|
|
yb2
Posts: 653
Joined: 1/30/2006
Status: offline
|
RE: phpMyAdmin - 9/4/2006 18:11:20
No, don't run what I wrote last, you've already done that. I've just installed phpmyadmin so I'm trying to work out what to do, but perhaps Jaybee or Spooky know?
_____________________________
it is natural for people not to see one's own faults, and to exaggerate other people's faults and failings.
Currently listening to: L'Enfer Des Formes by Stereolab
| |
|
|
|
yb2
Posts: 653
Joined: 1/30/2006
Status: offline
|
RE: phpMyAdmin - 9/4/2006 19:47:55
I've been working those sorts of hours lately, so I sympathise with you. If you can't sleep I'll be up tonight working, so you can chat to me! ( if an offer like that doesn't help you get to sleep, I don't know what will! :)
My PHP isn't working, I must've done something but don't know what so can't get phpMyAdmin working (sigh). But if you are able to run any sql, you could try this
GRANT USAGE ON *.* TO 'xxxxxxx'@'localhost' GRANT Select, Insert, Update, Delete,
ON `database`.* TO 'xxxxxxx'@'localhost'
that will set up an restricted account that php could use to connect to mysql
hope you get it working!
_____________________________
it is natural for people not to see one's own faults, and to exaggerate other people's faults and failings.
Currently listening to: L'Enfer Des Formes by Stereolab
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
k¥ 
