Jump to content



Welcome to AstaHost - Dear Guest , Please Register here to get Your own website. - Ask a Question / Express Opinion / Reply w/o Sign-Up!
Photo
- - - - -

I Have A Question About MySQL Access & Quotas


1 reply to this topic

#1 Nemisis

Nemisis

    Member [ Level 2 ]

  • Members
  • 51 posts

Posted 26 August 2005 - 01:16 AM

On my previous web host, I surpassed my MySQL quota limit. At least, that's what they told me. The following message is the error I get.

phpBB : Critical Error

Error creating new session

DEBUG MODE

SQL Error : 1044 Access denied for user: 'darnem_trials@65.98.98.74' to database 'darnem_trials'

INSERT INTO phpbb_sessions (session_id, session_user_id, session_start, session_time, session_ip, session_page, session_logged_in) VALUES ('7719681862d0a4bfc392929af1357326', 2, 1125023783, 1125023783, '18d160ac', 0, 1)

Line : 168
File : sessions.php


Now, my question is this, am I able to retrieve whatever I had on that website? If so, I need to transfer to this web host. Any help here?

Edited by microscopic^earthling, 26 August 2005 - 04:03 AM.


#2 yordan

yordan

    Way Out Of Control - You need a life :)

  • [MODERATOR]
  • 4,677 posts

Posted 26 August 2005 - 10:16 AM

Basically, transferring things from old_server to astahast shold be rather simple. I did not do it recently, but it should be rather straightforward.
1) On old_server, make a full database backup. Your server probably has it's tools for making the database backup, else you will have to learn how mysql does it.
2) Backup your whole site on your own pc, including the database backup. By the way, you should have done this every day, because in case of crash of your server, you need to have a backup.
3) Transfer all your files on Astahost.
4) Create your database on astahost. Remember your administrator names. I would suggest create on astahost new administrator names with the same names as on your old_server administrator names.
5) If necessary, check your php installation, probably some config files are false or need setup.
6) import your database, look your cpanel or read the mysql docs.

Hope this helped.



Reply to this topic



  


0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users