View Full Version : MySQl probs after moving server
I used you auto function to move to new and dedicated MySQL server. This seemed to go smoothly in the ops area, but not further.... I cannot access the db neither from the site (using new config) or using MySQL Front.
mysql://xxxxx:@mysql04.powweb.com/jims failed to connectAccess denied for user: 'xxxx@orion.powweb.com' (Using password: YES)
Reg
stormS
alphadesk
7-14-03, 08:08 AM
If you moved your DB over per the announcement and are getting error messages, please post here in this thread with your domain name.
Yes...just did that also for one of mine and getting connection error now. Tried resetting password and still a no go....
I'll get with admin and refer him to this thread.
RocketJeff
7-14-03, 10:44 AM
I just tried it, and I can access my old database still (on pulsar) but can't get to the new location (on mysql04).
Either the automated process isn't working or there's a time lag (which they should state on the transfer page).
I just moved and am getting access problems as well.
www.iklopstudios.com
devinemke
7-14-03, 11:04 AM
i moved my db (www.one-story.com) from saturn.powweb.com to mysql04.powweb.com and i'm having connection problems too. it seems that the move trashed all my tables as well as all of my mysql users.
www.flyin.com
Moved DB and having problems.
Fred Drouven
7-14-03, 11:28 AM
Also moved via OPS from meteor to mysql04 and having problems to, sure I updated my dbconnect. MySQL front-end doesn't work either.
The database is gone at meteor, but my db-users stil exist. And I cannot connect to mysql04 with my db-user/password
http://www.necrotania.com
Similar error message to the one at the top
Access denied for user: 'nec_forum@io.powweb.com'
4 different scripts with 3 different user names, if that matters.
me too
from asteroid.powweb to mysql04.powweb.com
www.vietbeauty.org
********EDIT*******
Ok i just add new user to my database and its connect fine but the problem is all the tables are GONE
and silly me NO BACKUP!! :(
********EDIT*******
Fred Drouven
7-14-03, 12:27 PM
After my move, it wasn't working either, I had to create new users (deleted and created the same user) on mysql04 and restored my database. That took a while, but it seems to work now.
I hope you all backup-ped folks.
I read in Powweb announcement that is better to move our mysql databases to new Mysql dedicated servers. In OPS are a 'Move' button to do this. I do this but with my habitual username/password I donīt access them. I create a new username and the database in clear. What's happen ?
older server: quasar.powweb.com
new server: mysql04.powweb.com
database: aidavitoria
I would think if thats the intended resolution of the "move" button they should re-write the instructions.
I think something else is happening to me as after changing the various configuration files over to the new mySQL server I still get "Access denied for user: 'flyindb@callisto.powweb.com' (Using password: YES)"
And nothing is pointing to my database still being on callisto.powweb.com.
cmschool
7-14-03, 03:33 PM
I moved my database from callisto.powweb.com to the dedicated mysql server via the move button under the mysql tab and even after changing the host name in my config.php files, I get the error could not connect to the database. Just wanted to let you know. Thanks.
discipulus
7-14-03, 04:48 PM
Problems here too. domain: deathyouthfoundation.com and dyfpunk.com
Updated all my scripts too and having similar problems as everyone else. Good thing I backed up my database before I did this!
< Edit >
I just deleted and recreated the same user and password as before. That has enabled me to connect to the database again, but now all my tables have disappeared.
< /Edit >
basogard
7-14-03, 05:07 PM
I'm not particularly savvy on this.. It took me too much time to figure out where Ikonboard stores it's variable to point to the database server.. Once I finally found it... yep, you guessed it,
Can't connect to mySQL database. Access denied for user: 'basogard@mars.powweb.com' (Using password: YES)
moved database from mars.powweb.com to mysql04.powweb.com
I hope this can be fixed without having to reload, because my database is not backed up with the latest. It's true it's only a forum for the family, but it would be nice if I didn't lose what was there!
I know I should have backed up the database before moving it. But then I thought, PW has tested this and it works, right? DOH!!!!
discipulus
7-14-03, 05:14 PM
Okay, good thing I backed up! I did what Fred Drouven did and now everything dealing with the database is working.
BACK UP YOUR DATABASE BEFORE MOVING IT!
Also, it won't be a bad idea to close your message board for a while before you do this.
Delete and recreate your user and you'll get it to work but the move button did not move anything.
So all of us who trusted the script lost the gamble.
I luckily did not have anything important in the mySQL but I am sure someone else did.
Is any one of powweb reply this thread ?. Is possible to recover information of the backup ?.
Please reply anything
Domain = too-graphic.com
Mysql = mysql04.powweb.com
DB = xfaq
Deleted user and recreated but no data. I did a backup, just need to figure out the restore.
Update
Restored DB everything is ok.
devinemke
7-14-03, 08:38 PM
through some trial and error I figured out this much:
moving your database from ***.powweb.com to mysql0*.powweb.com (as suggested by powweb) does a few things:
1. trashes all of your tables (your db is still there but all of the tables are gone).
2. trashes all of your users (they are still listed in OPS but they are gone too).
Here's what I recommend. If you aren't that savvy with PHP/mySQL, then don't bother moving. If you are here's things to keep in mind:
1. backup your database schema before the move
2. Do the move (in OPS)
3. Delete and recreate all of your mySQL users (in OPS)
4. rewrite all of your scripts with mySQL connection routines to point to the new server (ie. mysql04.powweb.com)
5. restore you backup from your saved schema. please note that for large database's, you may have trouble if you are using phpMyAdmin or any other server based admin tool since the script will time out before the backup is done. One way around this is to set a custom php.ini file that raises the max_execution_time directive to something higher. Another is to break your schema down into smaller parts and restore one part at a time (I found that I had to save the schema of each table separately and restore one at a time).
hope this helps
I have to say i'm a bit pissed at powweb for recommending this move without a warning of the above pitfalls.
Until I head a official responce from Powweb I am not touching anything. I have no SQL backups since I do not have a good way of generating them (Dial up stinks).
Soooo. If this is true and I lost the data then I am in trouble.
Sigh.
Please respond soon Powweb so I know if I need to try and repost my stories.
Sayain_Trunks
7-14-03, 09:49 PM
I get this error message
Warning: mysql_connect(): Access denied for user: 'Michael_Murray@www03.powweb.com' (Using password: YES) in /www/s/super_trunks/htdocs/Discussions/sources/Drivers/mySQL.php on line 64
Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in /www/s/super_trunks/htdocs/Discussions/sources/Drivers/mySQL.php on line 67
ERROR: Cannot find database DBZForms
Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /www/s/super_trunks/htdocs/Discussions/sources/Drivers/mySQL.php on line 100
http://www.dragonballzrealm.net
I also reset my password and still a no go. I did not try to move my database or anything as it is on mysql01.powweb.com
PLEASE HELP!!!!!
RocketJeff
7-14-03, 11:10 PM
Originally posted by Calash
Until I head a official responce from Powweb I am not touching anything. I have no SQL backups since I do not have a good way of generating them (Dial up stinks).
Soooo. If this is true and I lost the data then I am in trouble.
In Powweb's defense, they did say that you should have a backup in case something went wrong.
My database is only used for messing around so it didn't matter that I trashed it. If I had one in production use, I would make sure I had a backup before moving it (and I wouldn't have tried moving it until I was sure it worked for other people).
tradestage
7-15-03, 04:23 AM
In response to Devin's detailed email on how to solve the problem:
Thanks for the very valuable info Devin. You saved me a big headache. I took your advice and right now I have mysql front resorting my entire database.
For the mysql newbies out there, I strongly recommend that you download mysql front. It's a great program that is a life saver at times like these. Just type the name into google.com to get a download.
Originally posted by RocketJeff
In Powweb's defense, they did say that you should have a backup in case something went wrong.
My database is only used for messing around so it didn't matter that I trashed it. If I had one in production use, I would make sure I had a backup before moving it (and I wouldn't have tried moving it until I was sure it worked for other people).
Every time I try to back it up over dialup it times out. Until I can find a better backup solution that does not open security holes I am stuck. So it is not me being stupid, just a bad situation. And I was not attacking Powweb at all, just asking for a update on the status.
Out of curiosity, are many people having these problems moving? I'm really trying to hold off migrating until absolutely necessary, but I'm guessing that it'll be coming soon.
I moved last night. My whole 58mb database was deleted and lost. Thankfully I backed up right before I did the move.
My mysql users were also still in the ops, however, they didn't work. I removed all the users and created them again. That fixed the access problem.
However, I had the problem of inputing all 58mb of my database again. That 58mb of my database is around 100,000 rows of data. It took me over 1 hour and 30 minutes to re-insert all of my information into my database using Cable Modem. I upload at 32kb/sec too.
Took forever. I would rather have not moved seeing as how my site was down for almost 2 hours.
Originally posted by Calash
Until I head a official responce from Powweb I am not touching anything. I have no SQL backups since I do not have a good way of generating them (Dial up stinks).
Soooo. If this is true and I lost the data then I am in trouble.
Sigh.
Please respond soon Powweb so I know if I need to try and repost my stories.
So by any chance we can get a backup of our database?
I agree with you (Dial up stinks)
I have the ability of backing up my 50 meg database!
But I hate risks!
I'm waiting for an offcial announcement!
I think that powweb should give us a definite answer about these issue, cause cause my database are wiped out and i don't know if i should setup a new tables and start the site all over again. If they have a backup copy of the database, it will save us alot of time.
so what i want to know is does powweb have a backup copy of the databases?
Given this, why in the world would anybody go through all this trouble? How long will the mysql servers on asteroid continue to work?
newcomer
7-16-03, 03:31 PM
Same old problem you guys are having... I just moved my database as per instruction we see in OPS and im getting the same message that " I cannot connect to database"...
website is http://www.yamladesi.com/desiforum
server from where I moved was "pulsar" and its not accessible now....
Thanks! for help....
Originally posted by Tien
I think that powweb should give us a definite answer about these issue, cause cause my database are wiped out and i don't know if i should setup a new tables and start the site all over again. If they have a backup copy of the database, it will save us alot of time. It doesn't look like we are going to get an answer about this. Nothing in the announcement since they made the request for us to move. I moved & was down 24hrs & no responce from a support email.
I finaly tried reinstalling my full sql backup but it would not install. I had to add each table back one at a time to get it working again. Thanks for the great help Powweb.
It looks like they are doing somethins, my errors are changing. I am not getting the "User XXX@io.powweb.com does not exsist" anymore, now I am getting "Table not found" errors.
Powweb has had a difficult week with the issues on Space, so I can understand the delay. I am just glad that it is being looked at :).
Originally posted by Calash
It looks like they are doing somethins, my errors are changing. I am not getting the "User XXX@io.powweb.com does not exsist" anymore, now I am getting "Table not found" errors.
Powweb has had a difficult week with the issues on Space, so I can understand the delay. I am just glad that it is being looked at :). I normall y would agree with you but if you look in the announcement section that thread was placed there while they were having problems with several servers. They should have tested it better before asking everyone to switch & not while having so many other problems. It also only takes a minute to say we are aware of the problem but instead NEVER said anything in the anouncement to any other thread that I know of.:(
Hi everyone,
If you need backups of your database, please email nick@powweb.com and he'll be able to assist you. Please provide him with your domain name and MySQL database name.
cmschool
7-17-03, 01:15 AM
Will these backups be free of charge?
alphadesk
7-17-03, 01:19 AM
cmschool
I think so...free of charge....just do as Andrew has posted. Nick will get to it as soon as he can.
Make sure you ask when you email Nick, if it's not I'm sure he will say so.
I haven't transfer my MySQL yet I want to know if my database is safe or are they gonna delet all the db on old servers as well!
I want to know to manage my backups!
I'm on Meteor
I started this thread after moving MySQL server from a site hosted at orion. That failed, casuing a lot of problems.... I have one more site at meteor that I'll change MySQL server for. I'll give you my tips, but they are allready mentioned by devinmike earlier in this thread...
1) BACKUP you db!!!!! Important
2) Do the move at a time of hour you know your site is not that visited....
3) Try the auto move button (if it still exists). Perhaps you are lucky and everything goes by the book, if not...
4) Reset all of your db username and passwords in the ops area an insert them again...
5) connect to your db using e.g MySQl front or admin. Remeber to change hostname..(eg. mysql04.powweb.com)... If you don't do this you might connect to your old location.... you don't wonna do that...
6) Check if your db is there... do a check on the tables and a repair..(just in case some table are corrupt after moving server... they might have been written to in the moment of transfeer, and that will cause corruption)
7) If your db is empty run a query to your backup.sql to re-insert all data.... (may take some time)
8) NBe sure that any script you use has the new db location....
9) If you still are stuck.. send me a mail at storms@sapperbase.com and I'll try to help you out as I know how frustrating it is to have the site down...
Best of luck
RocketJeff
7-17-03, 09:29 AM
Originally posted by Storms
I started this thread after moving MySQL server from a site hosted at orion. That failed, casuing a lot of problems.... I have one more site at meteor that I'll change MySQL server for. I'll give you my tips, but they are allready mentioned by devinmike earlier in this thread...
Better yet, if you have a database that you're using for a live website, I'd wait until Powweb has things figured out.
But, if you're going to do it, backup your database first. That goes for any time you do anything (major or minor) to your database.
Powweb has recover my lost database. Many Thanks :)
I have my MySQL database on asteroid, and there is no "move" button in the MySQL section of OPS.
Maybe they've gone back to the drawing boards.
cmschool
7-24-03, 08:18 AM
I sent an email to Nick about a week ago and my database still has yet to be restored. Any idea how long this takes or how busy he is? Maybe my email just fell through the cracks?
I am still waiting as well. I have sent 2 emails and no responce.
I am starting to get frustrated.
I just sent another email today. This makes 3 with no reply yet.
I just sent a email to support with this information. I need to know one way or the other.
vBulletin v3.6.0, Copyright ©2000-2009, Jelsoft Enterprises Ltd.