Please delete it....
Delete all files and database SQLife in ftp.hosting.ws.
Hello,
I can think of two ways to do this, but the second varies.
1.) You can execute abbit of PHP to empty the tables:
//here i'll write function to empty a certain table in the SQL DB
function delete_sql_data(){
$host = "SQL_HOST";
$user = "SQL_USER";
$password = "SQL_PASSWORD";
mysql_connect($host, $user, $password);
$empty_table = "TRUNCATE TABLE **TABLE NAME HERE**"or die (mysql_error());
if ($empty_table){
echo "everything worked fine, and all the data in the table has been deleted";
}
else if (!$empty_table){
echo "something went wrong, check the code.";
}
}
delete_sql_data();
Now what you need to do with the code above:
1.) create a new PHP page (with the .php extension)
2.) copy the code above and paste into the source of the php page you just created.
3.) change the following values:
i.) change "SQL_HOST" to your database host.
ii.) change "SQL_USER" to your database username.
iii.) change "SQL_PASWORD" to your database password.
iiii.) change "***TABLE NAME HERE***" to the table you want to empty.
once thats done, save the page onto your .ws server and run it in your browser. You should see this messege on the screen:
everything worked fine, and all the data in the table has been deleted if you do see that messege, great. If you see this one instead:
something went wrong, check the code. then you have done something wrong. go over the code. if you still see the issue after fixing any errors, let me know.
Unfortunately, you cannot drop (delete) tables with PHP and your standard SQL user due to certain privileges set. But if you want to delete the table, read my second suggestion.
Now the other option is allot easier BUT will only be useful if your using one of the plugin's and you are happy for ALL of your data (for that plugin) to go. When i say ALL, I mean everything for that plugin. So if it's WordPress, all posts, comments, drafts, settings, etc etc will go.
Taking a look at your site, I see your using the forum plugin.
To erase all data (including SQL data), follow the steps below:
1.) Login to your members area.
2.) Navigate to the plugins page
3.) Click options on the plugin that stores the data that you would like to erase (in your case, the Forum).
4.) Click Delete
and thats it. everything will go. Be sure not to click turn off as that will only turn the plugin off (not erase the data until 60 days).
Thats all i can think of, but hopefully, the above suggestions should be all you need.
Nav
