Skip to content
View in the app

A better way to browse. Learn more.

Web Designer Forum

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

MySQL database help

Featured Replies

Ok I have been very stupid. I wanted to update the blog (wordpress) version on my first website and basically deleted the wordpress folder from the server. I have created a new database on MySQL for the new version as I couldn't find the password for the one for the older version. 

 

I have since found it out. Basically I need to (I think) move all the info from the old database to the new one as atm all the posts have gone. Am I right in saying that all the posts and info etc will be on the database or would it all have been in the folder on the server?

 

I know I have been a very silly girl but I really need someone's help to put it right.

 

I would like to sort this out myself with guidance from someone rather than someone to do it all for me.

 

So you will have to be patient if you want to help :)

 

I am prepared to pay a little bit if necessary to get on top of this.

 

Thanks guys. 

Hi there

 

Can you see your old database in phpmyadmin, can you access it in any way.

 

Pat

have you got the old database available to you?

 

if you dont, do have the following info:-

 

what accsess do you have? (root or user)

do you use a web panel to admin your hosting, if so which one?

if you have accses to the old database, forget the new database and remove it later, make a new user to connect to mysql and give it permission to use the old database, then goto the install url but change install.php to upgrade.php, give the updater the info for the new database user and bob's your uncle your back online.

 

[EDIT: no reward needed btw.... for me at least :)]

  • Author

WOW quick response!

Yes i can access it - i'll add a snapshot here so u can see what i can see. I access it through namesco cpanel.

 

fast response is allways nice :)

 

ok well, in cpanel, make a new mysql user and follow the instructions in my second post ^^^ and you should be sorted

  • Author

Thanks snider for the info....not quite sure how I do that....is there nothing on my new database that i need to save?

 

Not sure how to create a new user :( give permissions lol or any of the other stuff. I am a bit freaked by the cock up i have made by going in blind ... me silly moo!

 

I think i can remove the new database... but guidance needed for the rest.

WOW quick response!

Yes i can access it - i'll add a snapshot here so u can see what i can see. I access it through namesco cpanel.

 

Up on the top tabs you have one that says export, click that,then scroll to bottom of page, select save as file then put any name in the filename template box,then press go, this will save a text file with a .sql extension.

 

once you have done that we will have a copy of your database

 

Pat

  • Author

@ Snider ...Ah i see add user here.... hold on

 

Have u got msn??

 

@ Pat ...now i'm more confused. What shall i do.....copy my database or try what snider is saying??

 

Oh bloomin eck guys sorry :(

  • Author

Aww Pat I'm sorry I am so grateful tho.

 

@Snider - k i have created a new user but don't see anywhere for permissions although i have a recollection of doing this previously....

 

Ok I edited the config so the old database is in there. So as an outsider now the blog looks the same as before I poo pood up.

 

Ahhhh I have just tried to login and all is well....thankyou!!! MUAH MUAH xx

Create an account or sign in to comment

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.